7: id NUMBER := OKC_API.G_MISS_NUM,
8: qte_id NUMBER := OKC_API.G_MISS_NUM,
9: cpl_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: date_sent OKL_QUOTE_PARTIES.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKL_QUOTE_PARTIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKL_QUOTE_PARTIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
9: cpl_id NUMBER := OKC_API.G_MISS_NUM,
10: object_version_number NUMBER := OKC_API.G_MISS_NUM,
11: date_sent OKL_QUOTE_PARTIES.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKL_QUOTE_PARTIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKL_QUOTE_PARTIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: qpt_code OKL_QUOTE_PARTIES.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: date_sent OKL_QUOTE_PARTIES.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
12: created_by NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKL_QUOTE_PARTIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKL_QUOTE_PARTIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: qpt_code OKL_QUOTE_PARTIES.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
18: delay_days NUMBER := OKC_API.G_MISS_NUM,
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
13: creation_date OKL_QUOTE_PARTIES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
14: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
15: last_update_date OKL_QUOTE_PARTIES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: qpt_code OKL_QUOTE_PARTIES.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
18: delay_days NUMBER := OKC_API.G_MISS_NUM,
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
16: last_update_login NUMBER := OKC_API.G_MISS_NUM,
17: qpt_code OKL_QUOTE_PARTIES.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
18: delay_days NUMBER := OKC_API.G_MISS_NUM,
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qpt_code OKL_QUOTE_PARTIES.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
18: delay_days NUMBER := OKC_API.G_MISS_NUM,
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
18: delay_days NUMBER := OKC_API.G_MISS_NUM,
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
26: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
19: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
26: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
27: g_miss_qpy_rec qpy_rec_type;
20: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
26: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
27: g_miss_qpy_rec qpy_rec_type;
28: TYPE qpy_tbl_type IS TABLE OF qpy_rec_type
21: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
26: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
27: g_miss_qpy_rec qpy_rec_type;
28: TYPE qpy_tbl_type IS TABLE OF qpy_rec_type
29: INDEX BY BINARY_INTEGER;
22: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
23: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
24: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
25: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
26: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR);
27: g_miss_qpy_rec qpy_rec_type;
28: TYPE qpy_tbl_type IS TABLE OF qpy_rec_type
29: INDEX BY BINARY_INTEGER;
30: TYPE qpyv_rec_type IS RECORD (
31: id NUMBER := OKC_API.G_MISS_NUM,
32: object_version_number NUMBER := OKC_API.G_MISS_NUM,
33: qte_id NUMBER := OKC_API.G_MISS_NUM,
34: cpl_id NUMBER := OKC_API.G_MISS_NUM,
35: date_sent OKL_QUOTE_PARTIES_V.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
36: qpt_code OKL_QUOTE_PARTIES_V.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: delay_days NUMBER := OKC_API.G_MISS_NUM,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
32: object_version_number NUMBER := OKC_API.G_MISS_NUM,
33: qte_id NUMBER := OKC_API.G_MISS_NUM,
34: cpl_id NUMBER := OKC_API.G_MISS_NUM,
35: date_sent OKL_QUOTE_PARTIES_V.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
36: qpt_code OKL_QUOTE_PARTIES_V.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: delay_days NUMBER := OKC_API.G_MISS_NUM,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: date_sent OKL_QUOTE_PARTIES_V.DATE_SENT%TYPE := OKC_API.G_MISS_DATE,
36: qpt_code OKL_QUOTE_PARTIES_V.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: delay_days NUMBER := OKC_API.G_MISS_NUM,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
36: qpt_code OKL_QUOTE_PARTIES_V.QPT_CODE%TYPE := OKC_API.G_MISS_CHAR,
37: delay_days NUMBER := OKC_API.G_MISS_NUM,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
37: delay_days NUMBER := OKC_API.G_MISS_NUM,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
38: allocation_percentage NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
39: email_address OKL_QUOTE_PARTIES.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_QUOTE_PARTIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
40: party_jtot_object1_code OKL_QUOTE_PARTIES.PARTY_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_QUOTE_PARTIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
41: party_object1_id1 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
42: party_object1_id2 OKL_QUOTE_PARTIES.PARTY_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_QUOTE_PARTIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_QUOTE_PARTIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43: contact_jtot_object1_code OKL_QUOTE_PARTIES.CONTACT_JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
44: contact_object1_id1 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_QUOTE_PARTIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_QUOTE_PARTIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_qpyv_rec qpyv_rec_type;
45: contact_object1_id2 OKL_QUOTE_PARTIES.CONTACT_OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
46: created_by NUMBER := OKC_API.G_MISS_NUM,
47: creation_date OKL_QUOTE_PARTIES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
48: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
49: last_update_date OKL_QUOTE_PARTIES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
50: last_update_login NUMBER := OKC_API.G_MISS_NUM);
51: g_miss_qpyv_rec qpyv_rec_type;
52: TYPE qpyv_tbl_type IS TABLE OF qpyv_rec_type
53: INDEX BY BINARY_INTEGER;