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,
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,
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,
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,
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,
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,