eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CTC_PVT dependencies on OKC_API

Line 7: id NUMBER := OKC_API.G_MISS_NUM,

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ctc_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

Line 8: cpl_id NUMBER := OKC_API.G_MISS_NUM,

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE ctc_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

Line 9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,

5: ---------------------------------------------------------------------------
6: TYPE ctc_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,

Line 10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

6: TYPE ctc_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,

Line 11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

7: id NUMBER := OKC_API.G_MISS_NUM,
8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

8: cpl_id NUMBER := OKC_API.G_MISS_NUM,
9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,

9: cro_code OKC_CONTACTS.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 14: object_version_number NUMBER := OKC_API.G_MISS_NUM,

10: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 15: created_by NUMBER := OKC_API.G_MISS_NUM,

11: object1_id1 OKC_CONTACTS.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,

Line 16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

12: object1_id2 OKC_CONTACTS.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

13: jtot_object1_code OKC_CONTACTS.jtot_object1_code%TYPE:= OKC_API.G_MISS_CHAR,
14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,

Line 18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

14: object_version_number NUMBER := OKC_API.G_MISS_NUM,
15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,

Line 19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,

15: created_by NUMBER := OKC_API.G_MISS_NUM,
16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,

Line 20: last_update_login NUMBER := OKC_API.G_MISS_NUM,

16: creation_date OKC_CONTACTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,

17: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,

18: last_update_date OKC_CONTACTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,

19: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

20: last_update_login NUMBER := OKC_API.G_MISS_NUM,
21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

21: primary_yn OKC_CONTACTS.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

22: RESOURCE_CLASS OKC_CONTACTS.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

23: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

24: attribute_category OKC_CONTACTS.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

25: attribute1 OKC_CONTACTS.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

26: attribute2 OKC_CONTACTS.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

27: attribute3 OKC_CONTACTS.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

28: attribute4 OKC_CONTACTS.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

29: attribute5 OKC_CONTACTS.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

30: attribute6 OKC_CONTACTS.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

31: attribute7 OKC_CONTACTS.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

32: attribute8 OKC_CONTACTS.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

33: attribute9 OKC_CONTACTS.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);

Line 38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

34: attribute10 OKC_CONTACTS.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);
42: g_miss_ctc_rec ctc_rec_type;

Line 39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

35: attribute11 OKC_CONTACTS.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);
42: g_miss_ctc_rec ctc_rec_type;
43: TYPE ctc_tbl_type IS TABLE OF ctc_rec_type

Line 40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,

36: attribute12 OKC_CONTACTS.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);
42: g_miss_ctc_rec ctc_rec_type;
43: TYPE ctc_tbl_type IS TABLE OF ctc_rec_type
44: INDEX BY BINARY_INTEGER;

Line 41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);

37: attribute13 OKC_CONTACTS.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
38: attribute14 OKC_CONTACTS.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
39: attribute15 OKC_CONTACTS.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
40: start_date OKC_CONTACTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
41: end_date OKC_CONTACTS.END_DATE%TYPE := OKC_API.G_MISS_DATE);
42: g_miss_ctc_rec ctc_rec_type;
43: TYPE ctc_tbl_type IS TABLE OF ctc_rec_type
44: INDEX BY BINARY_INTEGER;
45:

Line 48: id NUMBER := OKC_API.G_MISS_NUM,

44: INDEX BY BINARY_INTEGER;
45:
46:
47: TYPE ctcv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

Line 49: object_version_number NUMBER := OKC_API.G_MISS_NUM,

45:
46:
47: TYPE ctcv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,

Line 50: cpl_id NUMBER := OKC_API.G_MISS_NUM,

46:
47: TYPE ctcv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

Line 51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,

47: TYPE ctcv_rec_type IS RECORD (
48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

Line 52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,

48: id NUMBER := OKC_API.G_MISS_NUM,
49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,

Line 53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,

49: object_version_number NUMBER := OKC_API.G_MISS_NUM,
50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,

Line 54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,

50: cpl_id NUMBER := OKC_API.G_MISS_NUM,
51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,

Line 55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,

51: cro_code OKC_CONTACTS_V.CRO_CODE%TYPE := OKC_API.G_MISS_CHAR,
52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,

Line 56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,

52: dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

Line 57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,

53: contact_sequence NUMBER := OKC_API.G_MISS_NUM,
54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

Line 58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,

54: object1_id1 OKC_CONTACTS_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

Line 59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,

55: object1_id2 OKC_CONTACTS_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

Line 60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,

56: jtot_object1_code OKC_CONTACTS_V.jtot_object1_code%TYPE := OKC_API.G_MISS_CHAR,
57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

Line 61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,

57: primary_yn OKC_CONTACTS_V.PRIMARY_YN%TYPE :=OKC_API.G_MISS_CHAR,
58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

Line 62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,

58: RESOURCE_CLASS OKC_CONTACTS_V.RESOURCE_CLASS%TYPE := OKC_API.G_MISS_CHAR,
59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

Line 63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,

59: SALES_GROUP_ID NUMBER := OKC_API.G_MISS_NUM,
60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

Line 64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,

60: attribute_category OKC_CONTACTS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

Line 65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,

61: attribute1 OKC_CONTACTS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

Line 66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,

62: attribute2 OKC_CONTACTS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

Line 67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,

63: attribute3 OKC_CONTACTS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

Line 68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,

64: attribute4 OKC_CONTACTS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

Line 69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,

65: attribute5 OKC_CONTACTS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

Line 70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,

66: attribute6 OKC_CONTACTS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

Line 71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,

67: attribute7 OKC_CONTACTS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

Line 72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,

68: attribute8 OKC_CONTACTS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,

Line 73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,

69: attribute9 OKC_CONTACTS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,

70: attribute10 OKC_CONTACTS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

Line 75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,

71: attribute11 OKC_CONTACTS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 76: created_by NUMBER := OKC_API.G_MISS_NUM,

72: attribute12 OKC_CONTACTS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,

Line 77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,

73: attribute13 OKC_CONTACTS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

Line 78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,

74: attribute14 OKC_CONTACTS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);

Line 79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,

75: attribute15 OKC_CONTACTS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);
83:

Line 80: last_update_login NUMBER := OKC_API.G_MISS_NUM,

76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);
83:
84: g_miss_ctcv_rec ctcv_rec_type;

Line 81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,

77: creation_date OKC_CONTACTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);
83:
84: g_miss_ctcv_rec ctcv_rec_type;
85: TYPE ctcv_tbl_type IS TABLE OF ctcv_rec_type

Line 82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);

78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKC_CONTACTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: last_update_login NUMBER := OKC_API.G_MISS_NUM,
81: start_date OKC_CONTACTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
82: end_date OKC_CONTACTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE);
83:
84: g_miss_ctcv_rec ctcv_rec_type;
85: TYPE ctcv_tbl_type IS TABLE OF ctcv_rec_type
86: INDEX BY BINARY_INTEGER;

Line 91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

87:
88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

88: ---------------------------------------------------------------------------
89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

89: -- GLOBAL MESSAGE CONSTANTS
90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

90: ---------------------------------------------------------------------------
91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

91: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

92: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

93: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------

Line 98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

94: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES

Line 99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

95: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------

Line 100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

96: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
97: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
98: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
99: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
100: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
104: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CTC_PVT';

Line 105: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

101: ---------------------------------------------------------------------------
102: -- GLOBAL VARIABLES
103: ---------------------------------------------------------------------------
104: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CTC_PVT';
105: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
106: ---------------------------------------------------------------------------
107: -- Procedures and Functions
108: ---------------------------------------------------------------------------
109:

Line 115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

111: PROCEDURE change_version;
112: PROCEDURE api_copy;
113: PROCEDURE insert_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_ctcv_rec IN ctcv_rec_type,

Line 124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

120: x_ctcv_rec OUT NOCOPY ctcv_rec_type);
121:
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_ctcv_tbl IN ctcv_tbl_type,

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

129: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type);
130:
131: PROCEDURE lock_row(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_ctcv_rec IN ctcv_rec_type);

Line 141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

137: p_ctcv_rec IN ctcv_rec_type);
138:
139: PROCEDURE lock_row(
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142: x_return_status OUT NOCOPY VARCHAR2,
143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_ctcv_tbl IN ctcv_tbl_type);

Line 149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

145: p_ctcv_tbl IN ctcv_tbl_type);
146:
147: PROCEDURE update_row(
148: p_api_version IN NUMBER,
149: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150: x_return_status OUT NOCOPY VARCHAR2,
151: x_msg_count OUT NOCOPY NUMBER,
152: x_msg_data OUT NOCOPY VARCHAR2,
153: p_ctcv_rec IN ctcv_rec_type,

Line 158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

154: x_ctcv_rec OUT NOCOPY ctcv_rec_type);
155:
156: PROCEDURE update_row(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_ctcv_tbl IN ctcv_tbl_type,

Line 167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

163: x_ctcv_tbl OUT NOCOPY ctcv_tbl_type);
164:
165: PROCEDURE delete_row(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_ctcv_rec IN ctcv_rec_type);

Line 175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

171: p_ctcv_rec IN ctcv_rec_type);
172:
173: PROCEDURE delete_row(
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_ctcv_tbl IN ctcv_tbl_type);

Line 183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

179: p_ctcv_tbl IN ctcv_tbl_type);
180:
181: PROCEDURE validate_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_ctcv_rec IN ctcv_rec_type);

Line 191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

187: p_ctcv_rec IN ctcv_rec_type);
188:
189: PROCEDURE validate_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_ctcv_tbl IN ctcv_tbl_type);