93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
94: G_MISS_khrv_rec khrv_rec_type;
95: TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
96: INDEX BY BINARY_INTEGER;
97: -- OKS_K_HEADERS_B Record Spec
98: TYPE khr_rec_type IS RECORD (
99: id NUMBER := OKC_API.G_MISS_NUM
100: , chr_id NUMBER := OKC_API.G_MISS_NUM
101: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
98: TYPE khr_rec_type IS RECORD (
99: id NUMBER := OKC_API.G_MISS_NUM
100: , chr_id NUMBER := OKC_API.G_MISS_NUM
101: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
102: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
104: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
105: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
99: id NUMBER := OKC_API.G_MISS_NUM
100: , chr_id NUMBER := OKC_API.G_MISS_NUM
101: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
102: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
104: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
105: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
107: , commitment_id NUMBER := OKC_API.G_MISS_NUM
100: , chr_id NUMBER := OKC_API.G_MISS_NUM
101: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
102: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
104: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
105: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
107: , commitment_id NUMBER := OKC_API.G_MISS_NUM
108: , grace_duration NUMBER := OKC_API.G_MISS_NUM
102: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
103: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
104: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
105: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
107: , commitment_id NUMBER := OKC_API.G_MISS_NUM
108: , grace_duration NUMBER := OKC_API.G_MISS_NUM
109: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
110: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
105: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
106: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
107: , commitment_id NUMBER := OKC_API.G_MISS_NUM
108: , grace_duration NUMBER := OKC_API.G_MISS_NUM
109: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
110: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
111: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
112: , tax_amount NUMBER := OKC_API.G_MISS_NUM
113: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
107: , commitment_id NUMBER := OKC_API.G_MISS_NUM
108: , grace_duration NUMBER := OKC_API.G_MISS_NUM
109: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
110: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
111: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
112: , tax_amount NUMBER := OKC_API.G_MISS_NUM
113: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
114: , tax_code NUMBER := OKC_API.G_MISS_NUM
115: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
109: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
110: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
111: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
112: , tax_amount NUMBER := OKC_API.G_MISS_NUM
113: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
114: , tax_code NUMBER := OKC_API.G_MISS_NUM
115: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
116: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
117: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
113: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
114: , tax_code NUMBER := OKC_API.G_MISS_NUM
115: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
116: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
117: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
118: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
119: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
120: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
121: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
114: , tax_code NUMBER := OKC_API.G_MISS_NUM
115: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
116: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
117: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
118: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
119: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
120: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
121: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
120: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
121: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
124: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
125: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
126: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
127: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
121: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
124: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
125: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
126: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
127: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
129: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
124: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
125: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
126: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
127: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
129: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
130: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
131: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
126: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
127: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
129: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
130: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
131: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
132: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
133: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
134: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
129: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
130: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
131: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
132: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
133: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
134: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
135: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
137: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
131: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
132: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
133: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
134: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
135: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
137: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
139: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
133: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
134: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
135: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
137: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
139: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
140: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
141: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
134: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
135: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
137: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
139: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
140: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
141: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
139: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
140: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
141: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
143: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
144: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
145: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
146: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
141: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
143: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
144: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
145: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
146: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
143: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
144: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
145: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
146: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
145: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
146: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
146: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
147: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
148: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
149: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
150: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158: , object_version_number NUMBER := OKC_API.G_MISS_NUM
151: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158: , object_version_number NUMBER := OKC_API.G_MISS_NUM
159: , request_id NUMBER := OKC_API.G_MISS_NUM
152: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158: , object_version_number NUMBER := OKC_API.G_MISS_NUM
159: , request_id NUMBER := OKC_API.G_MISS_NUM
160: , created_by NUMBER := OKC_API.G_MISS_NUM
153: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
154: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
155: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
156: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158: , object_version_number NUMBER := OKC_API.G_MISS_NUM
159: , request_id NUMBER := OKC_API.G_MISS_NUM
160: , created_by NUMBER := OKC_API.G_MISS_NUM
161: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
157: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
158: , object_version_number NUMBER := OKC_API.G_MISS_NUM
159: , request_id NUMBER := OKC_API.G_MISS_NUM
160: , created_by NUMBER := OKC_API.G_MISS_NUM
161: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
162: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
163: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_update_login NUMBER := OKC_API.G_MISS_NUM
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
159: , request_id NUMBER := OKC_API.G_MISS_NUM
160: , created_by NUMBER := OKC_API.G_MISS_NUM
161: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
162: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
163: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_update_login NUMBER := OKC_API.G_MISS_NUM
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
166: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
161: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
162: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
163: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_update_login NUMBER := OKC_API.G_MISS_NUM
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
166: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
162: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
163: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_update_login NUMBER := OKC_API.G_MISS_NUM
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
166: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
163: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_update_login NUMBER := OKC_API.G_MISS_NUM
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
166: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
165: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
166: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
167: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
168: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
169: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
170: , accepted_by NUMBER := OKC_API.G_MISS_NUM
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
171: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
172: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
173: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
174: , process_request_id NUMBER := OKC_API.G_MISS_NUM
175: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
176: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
184: G_MISS_khr_rec khr_rec_type;
177: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
184: G_MISS_khr_rec khr_rec_type;
185: TYPE khr_tbl_type IS TABLE OF khr_rec_type
178: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
184: G_MISS_khr_rec khr_rec_type;
185: TYPE khr_tbl_type IS TABLE OF khr_rec_type
186: INDEX BY BINARY_INTEGER;
179: , person_party_id NUMBER := OKC_API.G_MISS_NUM
180: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
181: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
182: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
184: G_MISS_khr_rec khr_rec_type;
185: TYPE khr_tbl_type IS TABLE OF khr_rec_type
186: INDEX BY BINARY_INTEGER;
187: ---------------------------------------------------------------------------