3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cdt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE cdt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE cdt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
6: TYPE cdt_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
8: cdt_type OKS_K_DEFAULTS.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: object_version_number NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
10: created_by NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
11: creation_date OKS_K_DEFAULTS.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
12: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
13: last_update_date OKS_K_DEFAULTS.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
14: segment_id1 OKS_K_DEFAULTS.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
15: segment_id2 OKS_K_DEFAULTS.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
16: jtot_object_code OKS_K_DEFAULTS.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
17: pdf_id NUMBER := OKC_API.G_MISS_NUM,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
18: qcl_id NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
19: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
20: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
21: price_list_id1 OKS_K_DEFAULTS.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
22: price_list_id2 OKS_K_DEFAULTS.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
23: renewal_type OKS_K_DEFAULTS.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
24: po_required_yn OKS_K_DEFAULTS.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
25: renewal_pricing_type OKS_K_DEFAULTS.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
26: markup_percent NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
27: start_date OKS_K_DEFAULTS.START_DATE%TYPE := OKC_API.G_MISS_DATE,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
28: end_date OKS_K_DEFAULTS.END_DATE%TYPE := OKC_API.G_MISS_DATE,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
29: --security_group_id NUMBER := OKC_API.G_MISS_NUM,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
30: rle_code OKS_K_DEFAULTS.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
31: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
32: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
33: revenue_estimated_period OKS_K_DEFAULTS.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
34: template_set_id NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
35: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
36: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
37: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
38: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
39: USER_ID NUMBER := OKC_API.G_MISS_NUM,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
40: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
41: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
42: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
43: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
44: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
45: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
46: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
47: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
48: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
49: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
50: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
51: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
52: -- R12 Data Model Changes 4485150 Start
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
53: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
54: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
56: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
57: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
58: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
66: -- R12 Data Model Changes 4485150 End
59: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
66: -- R12 Data Model Changes 4485150 End
67: );
60: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
66: -- R12 Data Model Changes 4485150 End
67: );
68: g_miss_cdt_rec cdt_rec_type;
61: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
62: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
64: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
65: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
66: -- R12 Data Model Changes 4485150 End
67: );
68: g_miss_cdt_rec cdt_rec_type;
69:
69:
70: TYPE cdt_tbl_type IS TABLE OF cdt_rec_type
71: INDEX BY BINARY_INTEGER;
72: TYPE cdtv_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
70: TYPE cdt_tbl_type IS TABLE OF cdt_rec_type
71: INDEX BY BINARY_INTEGER;
72: TYPE cdtv_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
71: INDEX BY BINARY_INTEGER;
72: TYPE cdtv_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
72: TYPE cdtv_rec_type IS RECORD (
73: id NUMBER := OKC_API.G_MISS_NUM,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
73: id NUMBER := OKC_API.G_MISS_NUM,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
74: cdt_type OKS_K_DEFAULTS_V.CDT_TYPE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
75: object_version_number NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
76: created_by NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
77: creation_date OKS_K_DEFAULTS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
78: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
79: last_update_date OKS_K_DEFAULTS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
80: segment_id1 OKS_K_DEFAULTS_V.SEGMENT_ID1%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
81: segment_id2 OKS_K_DEFAULTS_V.SEGMENT_ID2%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
82: jtot_object_code OKS_K_DEFAULTS_V.JTOT_OBJECT_CODE%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
83: pdf_id NUMBER := OKC_API.G_MISS_NUM,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
84: qcl_id NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
85: cgp_new_id NUMBER := OKC_API.G_MISS_NUM,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
86: cgp_renew_id NUMBER := OKC_API.G_MISS_NUM,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
87: price_list_id1 OKS_K_DEFAULTS_V.PRICE_LIST_ID1%TYPE := OKC_API.G_MISS_CHAR,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
88: price_list_id2 OKS_K_DEFAULTS_V.PRICE_LIST_ID2%TYPE := OKC_API.G_MISS_CHAR,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
89: renewal_type OKS_K_DEFAULTS_V.RENEWAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
90: po_required_yn OKS_K_DEFAULTS_V.PO_REQUIRED_YN%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
91: renewal_pricing_type OKS_K_DEFAULTS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
92: markup_percent NUMBER := OKC_API.G_MISS_NUM,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
93: rle_code OKS_K_DEFAULTS_V.RLE_CODE%TYPE := OKC_API.G_MISS_CHAR,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
94: start_date OKS_K_DEFAULTS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
95: end_date OKS_K_DEFAULTS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
96: revenue_estimated_percent NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
97: revenue_estimated_duration NUMBER := OKC_API.G_MISS_NUM,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
98: revenue_estimated_period OKS_K_DEFAULTS_V.REVENUE_ESTIMATED_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
99: template_set_id NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
100: THRESHOLD_CURRENCY OKS_K_DEFAULTS.THRESHOLD_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
101: THRESHOLD_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
102: EMAIL_ADDRESS OKS_K_DEFAULTS.EMAIL_ADDRESS%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
103: BILLING_PROFILE_ID NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
104: USER_ID NUMBER := OKC_API.G_MISS_NUM,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
105: THRESHOLD_ENABLED_YN OKS_K_DEFAULTS.THRESHOLD_ENABLED_YN%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
106: GRACE_PERIOD OKS_K_DEFAULTS.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
107: GRACE_DURATION NUMBER := OKC_API.G_MISS_NUM,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
108: PAYMENT_TERMS_ID1 OKS_K_DEFAULTS.PAYMENT_TERMS_ID1%TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
109: PAYMENT_TERMS_ID2 OKS_K_DEFAULTS.PAYMENT_TERMS_ID2%TYPE := OKC_API.G_MISS_CHAR,
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
110: EVERGREEN_THRESHOLD_CURR OKS_K_DEFAULTS.EVERGREEN_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
111: EVERGREEN_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
112: PAYMENT_METHOD OKS_K_DEFAULTS.PAYMENT_METHOD%TYPE := OKC_API.G_MISS_CHAR,
113: PAYMENT_THRESHOLD_CURR OKS_K_DEFAULTS.PAYMENT_THRESHOLD_CURR%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
114: PAYMENT_THRESHOLD_AMT NUMBER := OKC_API.G_MISS_NUM,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
115: INTERFACE_PRICE_BREAK OKS_K_DEFAULTS.INTERFACE_PRICE_BREAK %TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
116: CREDIT_AMOUNT OKS_K_DEFAULTS.CREDIT_AMOUNT %TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
117: -- R12 Data Model Changes 4485150 Start /* mmadhavi 4485150 : add other columns */
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
118: PERIOD_TYPE OKS_K_DEFAULTS.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
119: PERIOD_START OKS_K_DEFAULTS.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
120: PRICE_UOM OKS_K_DEFAULTS.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
121: BASE_CURRENCY OKS_K_DEFAULTS.BASE_CURRENCY%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: APPROVAL_TYPE OKS_K_DEFAULTS.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
123: EVERGREEN_APPROVAL_TYPE OKS_K_DEFAULTS.EVERGREEN_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
131: -- R12 Data Model Changes 4485150 End
124: ONLINE_APPROVAL_TYPE OKS_K_DEFAULTS.ONLINE_APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
131: -- R12 Data Model Changes 4485150 End
132: );
125: PURCHASE_ORDER_FLAG OKS_K_DEFAULTS.PURCHASE_ORDER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
131: -- R12 Data Model Changes 4485150 End
132: );
133: g_miss_cdtv_rec cdtv_rec_type;
126: CREDIT_CARD_FLAG OKS_K_DEFAULTS.CREDIT_CARD_FLAG%TYPE := OKC_API.G_MISS_CHAR,
127: WIRE_FLAG OKS_K_DEFAULTS.WIRE_FLAG%TYPE := OKC_API.G_MISS_CHAR,
128: COMMITMENT_NUMBER_FLAG OKS_K_DEFAULTS.COMMITMENT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR,
129: CHECK_FLAG OKS_K_DEFAULTS.CHECK_FLAG%TYPE := OKC_API.G_MISS_CHAR,
130: TEMPLATE_LANGUAGE OKS_K_DEFAULTS.TEMPLATE_LANGUAGE%TYPE := OKC_API.G_MISS_CHAR
131: -- R12 Data Model Changes 4485150 End
132: );
133: g_miss_cdtv_rec cdtv_rec_type;
134: TYPE cdtv_tbl_type IS TABLE OF cdtv_rec_type
135: INDEX BY BINARY_INTEGER;
136: ---------------------------------------------------------------------------
137: -- GLOBAL MESSAGE CONSTANTS
138: ---------------------------------------------------------------------------
139: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
136: ---------------------------------------------------------------------------
137: -- GLOBAL MESSAGE CONSTANTS
138: ---------------------------------------------------------------------------
139: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
137: -- GLOBAL MESSAGE CONSTANTS
138: ---------------------------------------------------------------------------
139: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
138: ---------------------------------------------------------------------------
139: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
139: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
140: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
141: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
149: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_DEFAULTS_UNEXPECTED_ERROR';
142: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
149: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_DEFAULTS_UNEXPECTED_ERROR';
150: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
143: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
149: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_DEFAULTS_UNEXPECTED_ERROR';
150: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
151: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
144: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
145: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
146: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
147: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
148: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
149: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_DEFAULTS_UNEXPECTED_ERROR';
150: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
151: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
152: ---------------------------------------------------------------------------
157: ---------------------------------------------------------------------------
158: -- GLOBAL VARIABLES
159: ---------------------------------------------------------------------------
160: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CDT_PVT';
161: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
162: ---------------------------------------------------------------------------
163: -- Procedures and Functions
164: ---------------------------------------------------------------------------
165:
167: PROCEDURE change_version;
168: PROCEDURE api_copy;
169: PROCEDURE insert_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_cdtv_rec IN cdtv_rec_type,
176: x_cdtv_rec OUT NOCOPY cdtv_rec_type);
177:
178: PROCEDURE insert_row(
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181: x_return_status OUT NOCOPY VARCHAR2,
182: x_msg_count OUT NOCOPY NUMBER,
183: x_msg_data OUT NOCOPY VARCHAR2,
184: p_cdtv_tbl IN cdtv_tbl_type,
185: x_cdtv_tbl OUT NOCOPY cdtv_tbl_type);
186:
187: PROCEDURE lock_row(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_cdtv_rec IN cdtv_rec_type);
193: p_cdtv_rec IN cdtv_rec_type);
194:
195: PROCEDURE lock_row(
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201: p_cdtv_tbl IN cdtv_tbl_type);
201: p_cdtv_tbl IN cdtv_tbl_type);
202:
203: PROCEDURE update_row(
204: p_api_version IN NUMBER,
205: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206: x_return_status OUT NOCOPY VARCHAR2,
207: x_msg_count OUT NOCOPY NUMBER,
208: x_msg_data OUT NOCOPY VARCHAR2,
209: p_cdtv_rec IN cdtv_rec_type,
210: x_cdtv_rec OUT NOCOPY cdtv_rec_type);
211:
212: PROCEDURE update_row(
213: p_api_version IN NUMBER,
214: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215: x_return_status OUT NOCOPY VARCHAR2,
216: x_msg_count OUT NOCOPY NUMBER,
217: x_msg_data OUT NOCOPY VARCHAR2,
218: p_cdtv_tbl IN cdtv_tbl_type,
219: x_cdtv_tbl OUT NOCOPY cdtv_tbl_type);
220:
221: PROCEDURE delete_row(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_cdtv_rec IN cdtv_rec_type);
227: p_cdtv_rec IN cdtv_rec_type);
228:
229: PROCEDURE delete_row(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_cdtv_tbl IN cdtv_tbl_type);
235: p_cdtv_tbl IN cdtv_tbl_type);
236:
237: PROCEDURE validate_row(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_cdtv_rec IN cdtv_rec_type);
243: p_cdtv_rec IN cdtv_rec_type);
244:
245: PROCEDURE validate_row(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_cdtv_tbl IN cdtv_tbl_type);