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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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);
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;
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
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;
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:
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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:
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
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;