DBA Data[Home] [Help]

APPS.OKC_CSO_PVT dependencies on OKC_CONTACT_SOURCES

Line 7: cro_code OKC_CONTACT_SOURCES.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

Line 8: rle_code OKC_CONTACT_SOURCES.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

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

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

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

Line 10: start_date OKC_CONTACT_SOURCES.START_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 11: end_date OKC_CONTACT_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,

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

Line 12: jtot_object_code OKC_CONTACT_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

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

Line 15: creation_date OKC_CONTACT_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

11: end_date OKC_CONTACT_SOURCES.END_DATE%TYPE := OKC_API.G_MISS_DATE,
12: jtot_object_code OKC_CONTACT_SOURCES.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CONTACT_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CONTACT_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: constrained_yn OKC_CONTACT_SOURCES.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 17: last_update_date OKC_CONTACT_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

13: object_version_number NUMBER := OKC_API.G_MISS_NUM,
14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CONTACT_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CONTACT_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: constrained_yn OKC_CONTACT_SOURCES.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: access_level OKC_CONTACT_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
21: g_miss_cso_rec cso_rec_type;

Line 18: constrained_yn OKC_CONTACT_SOURCES.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,

14: created_by NUMBER := OKC_API.G_MISS_NUM,
15: creation_date OKC_CONTACT_SOURCES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CONTACT_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: constrained_yn OKC_CONTACT_SOURCES.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: access_level OKC_CONTACT_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
21: g_miss_cso_rec cso_rec_type;
22: TYPE cso_tbl_type IS TABLE OF cso_rec_type

Line 20: access_level OKC_CONTACT_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

16: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
17: last_update_date OKC_CONTACT_SOURCES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
18: constrained_yn OKC_CONTACT_SOURCES.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
19: last_update_login NUMBER := OKC_API.G_MISS_NUM,
20: access_level OKC_CONTACT_SOURCES.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
21: g_miss_cso_rec cso_rec_type;
22: TYPE cso_tbl_type IS TABLE OF cso_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE csov_rec_type IS RECORD (

Line 25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,

21: g_miss_cso_rec cso_rec_type;
22: TYPE cso_tbl_type IS TABLE OF cso_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE csov_rec_type IS RECORD (
25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,

22: TYPE cso_tbl_type IS TABLE OF cso_rec_type
23: INDEX BY BINARY_INTEGER;
24: TYPE csov_rec_type IS RECORD (
25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

Line 27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,

23: INDEX BY BINARY_INTEGER;
24: TYPE csov_rec_type IS RECORD (
25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

24: TYPE csov_rec_type IS RECORD (
25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,

Line 29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,

25: rle_code OKC_CONTACT_SOURCES_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,

26: cro_code OKC_CONTACT_SOURCES_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
27: buy_or_sell OKC_CONTACT_SOURCES_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,

28: start_date OKC_CONTACT_SOURCES_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
29: end_date OKC_CONTACT_SOURCES_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKC_CONTACT_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

30: jtot_object_code OKC_CONTACT_SOURCES_V.jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKC_CONTACT_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM,
38: access_level OKC_CONTACT_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

Line 36: last_update_date OKC_CONTACT_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

32: constrained_yn OKC_CONTACT_SOURCES_V.CONSTRAINED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: created_by NUMBER := OKC_API.G_MISS_NUM,
34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKC_CONTACT_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM,
38: access_level OKC_CONTACT_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_csov_rec csov_rec_type;
40: TYPE csov_tbl_type IS TABLE OF csov_rec_type

Line 38: access_level OKC_CONTACT_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);

34: creation_date OKC_CONTACT_SOURCES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
35: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
36: last_update_date OKC_CONTACT_SOURCES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
37: last_update_login NUMBER := OKC_API.G_MISS_NUM,
38: access_level OKC_CONTACT_SOURCES_V.ACCESS_LEVEL%TYPE := OKC_API.G_MISS_CHAR);
39: g_miss_csov_rec csov_rec_type;
40: TYPE csov_tbl_type IS TABLE OF csov_rec_type
41: INDEX BY BINARY_INTEGER;
42: ---------------------------------------------------------------------------