DBA Data[Home] [Help]

APPS.OKC_RDS_PVT dependencies on OKC_RULE_DEF_SOURCES

Line 7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rds_rec_type IS RECORD (
7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rds_rec_type IS RECORD (
7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE rds_rec_type IS RECORD (
7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

Line 10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,

6: TYPE rds_rec_type IS RECORD (
7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object_id_number NUMBER := OKC_API.G_MISS_NUM,

Line 11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

7: rgr_rgd_code OKC_RULE_DEF_SOURCES.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object_id_number NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

8: rgr_rdf_code OKC_RULE_DEF_SOURCES.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object_id_number NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

9: buy_or_sell OKC_RULE_DEF_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
10: access_level OKC_RULE_DEF_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
11: start_date OKC_RULE_DEF_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
12: end_date OKC_RULE_DEF_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object_id_number NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_DEF_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 17: creation_date OKC_RULE_DEF_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

13: jtot_object_code OKC_RULE_DEF_SOURCES.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
14: object_id_number NUMBER := OKC_API.G_MISS_NUM,
15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_DEF_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_DEF_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM);
21: g_miss_rds_rec rds_rec_type;

Line 19: last_update_date OKC_RULE_DEF_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

15: object_version_number NUMBER := OKC_API.G_MISS_NUM,
16: created_by NUMBER := OKC_API.G_MISS_NUM,
17: creation_date OKC_RULE_DEF_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
18: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
19: last_update_date OKC_RULE_DEF_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM);
21: g_miss_rds_rec rds_rec_type;
22: TYPE rds_tbl_type IS TABLE OF rds_rec_type
23: INDEX BY BINARY_INTEGER;

Line 26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,

22: TYPE rds_tbl_type IS TABLE OF rds_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE rdsv_rec_type IS RECORD (
25: row_id ROWID,
26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,

Line 27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,

23: INDEX BY BINARY_INTEGER;
24: TYPE rdsv_rec_type IS RECORD (
25: row_id ROWID,
26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,

24: TYPE rdsv_rec_type IS RECORD (
25: row_id ROWID,
26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,

25: row_id ROWID,
26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,

26: jtot_object_code OKC_RULE_DEF_SOURCES_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33: object_version_number NUMBER := OKC_API.G_MISS_NUM,
34: object_id_number NUMBER := OKC_API.G_MISS_NUM,

Line 31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

27: rgr_rgd_code OKC_RULE_DEF_SOURCES_V.RGR_RGD_CODE%TYPE := OKC_API.G_MISS_CHAR,
28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33: object_version_number NUMBER := OKC_API.G_MISS_NUM,
34: object_id_number NUMBER := OKC_API.G_MISS_NUM,
35: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

28: rgr_rdf_code OKC_RULE_DEF_SOURCES_V.RGR_RDF_CODE%TYPE := OKC_API.G_MISS_CHAR,
29: buy_or_sell OKC_RULE_DEF_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
30: access_level OKC_RULE_DEF_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR,
31: start_date OKC_RULE_DEF_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33: object_version_number NUMBER := OKC_API.G_MISS_NUM,
34: object_id_number NUMBER := OKC_API.G_MISS_NUM,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKC_RULE_DEF_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 36: creation_date OKC_RULE_DEF_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

32: end_date OKC_RULE_DEF_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
33: object_version_number NUMBER := OKC_API.G_MISS_NUM,
34: object_id_number NUMBER := OKC_API.G_MISS_NUM,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKC_RULE_DEF_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: last_update_date OKC_RULE_DEF_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: g_miss_rdsv_rec rdsv_rec_type;

Line 38: last_update_date OKC_RULE_DEF_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

34: object_id_number NUMBER := OKC_API.G_MISS_NUM,
35: created_by NUMBER := OKC_API.G_MISS_NUM,
36: creation_date OKC_RULE_DEF_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
38: last_update_date OKC_RULE_DEF_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
39: last_update_login NUMBER := OKC_API.G_MISS_NUM);
40: g_miss_rdsv_rec rdsv_rec_type;
41: TYPE rdsv_tbl_type IS TABLE OF rdsv_rec_type
42: INDEX BY BINARY_INTEGER;