Sys_ Concurrency Management Series 6_ concurrency program parameter default value setting (concept)

2014-06-21 Created by Baoxinjian

I. Summary

When setting the concurrent program, we need to set the default value for parameter, and the implementation of the linkage of some parameter in Concurrent programs can also be realized by default value.

1. Constand

2. Segment

3. Profile

4. SQL Statement

5. Current time and Date

Second, the parameter specific setting simple example

1. Constant

2. Segment

3. Profile

4. SQL Statement

(1). SELECT To_number (oe_sys_parameters. VALUE (' set_of_books_id '))
From DUAL;
(2). SELECT: $flex $.xxont_4394_srs_pick_slip_number
From DUAL;
(3). Selectorganization_code
From Org_organization_definitions
WHERE organization_id =: $profiles $.mfg_organization_id;

5. Current time or current Date

Thanks and regards

Sys_ Concurrency Management Series 6_ concurrency program parameter default value setting (concept)