DBA Data[Home] [Help]

APPS.OKC_RSC_PVT dependencies on OKC_ROLE_SOURCES

Line 7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

Line 8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

5: ---------------------------------------------------------------------------
6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

6: TYPE rsc_rec_type IS RECORD (
7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

7: rle_code OKC_ROLE_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
8: buy_or_sell OKC_ROLE_SOURCES.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
9: start_date OKC_ROLE_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,
10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

10: end_date OKC_ROLE_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
11: jtot_object_code OKC_ROLE_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

Line 16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

12: object_version_number NUMBER := OKC_API.G_MISS_NUM,
13: created_by NUMBER := OKC_API.G_MISS_NUM,
14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type

Line 18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

14: creation_date OKC_ROLE_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
15: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
16: last_update_date OKC_ROLE_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_update_login NUMBER := OKC_API.G_MISS_NUM,
18: access_level OKC_ROLE_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (

Line 23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

19: g_miss_rsc_rec rsc_rec_type;
20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

Line 24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,

20: TYPE rsc_tbl_type IS TABLE OF rsc_rec_type
21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

21: INDEX BY BINARY_INTEGER;
22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

22: TYPE rscv_rec_type IS RECORD (
23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

23: rle_code OKC_ROLE_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
24: buy_or_sell OKC_ROLE_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
25: start_date OKC_ROLE_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

26: end_date OKC_ROLE_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
27: jtot_object_code OKC_ROLE_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

Line 32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

28: object_version_number NUMBER := OKC_API.G_MISS_NUM,
29: created_by NUMBER := OKC_API.G_MISS_NUM,
30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type

Line 34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

30: creation_date OKC_ROLE_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
31: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
32: last_update_date OKC_ROLE_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
33: last_update_login NUMBER := OKC_API.G_MISS_NUM,
34: access_level OKC_ROLE_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
35: g_miss_rscv_rec rscv_rec_type;
36: TYPE rscv_tbl_type IS TABLE OF rscv_rec_type
37: INDEX BY BINARY_INTEGER;
38: ---------------------------------------------------------------------------