2: /* $Header: OKSSKHRS.pls 120.5.12020000.2 2013/02/13 06:23:03 mchandak ship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_K_HEADERS_V Record Spec
7: TYPE khrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: , chr_id NUMBER := OKC_API.G_MISS_NUM
10: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
7: TYPE khrv_rec_type IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: , chr_id NUMBER := OKC_API.G_MISS_NUM
10: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
11: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
8: id NUMBER := OKC_API.G_MISS_NUM
9: , chr_id NUMBER := OKC_API.G_MISS_NUM
10: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
11: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16: , commitment_id NUMBER := OKC_API.G_MISS_NUM
9: , chr_id NUMBER := OKC_API.G_MISS_NUM
10: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
11: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16: , commitment_id NUMBER := OKC_API.G_MISS_NUM
17: , grace_duration NUMBER := OKC_API.G_MISS_NUM
11: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
12: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
13: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
14: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16: , commitment_id NUMBER := OKC_API.G_MISS_NUM
17: , grace_duration NUMBER := OKC_API.G_MISS_NUM
18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
19: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
14: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
16: , commitment_id NUMBER := OKC_API.G_MISS_NUM
17: , grace_duration NUMBER := OKC_API.G_MISS_NUM
18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
19: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
20: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
21: , tax_amount NUMBER := OKC_API.G_MISS_NUM
22: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
16: , commitment_id NUMBER := OKC_API.G_MISS_NUM
17: , grace_duration NUMBER := OKC_API.G_MISS_NUM
18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
19: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
20: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
21: , tax_amount NUMBER := OKC_API.G_MISS_NUM
22: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
23: , tax_code NUMBER := OKC_API.G_MISS_NUM
24: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
19: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
20: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
21: , tax_amount NUMBER := OKC_API.G_MISS_NUM
22: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
23: , tax_code NUMBER := OKC_API.G_MISS_NUM
24: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
25: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
26: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
22: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
23: , tax_code NUMBER := OKC_API.G_MISS_NUM
24: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
25: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
26: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
27: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
28: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
23: , tax_code NUMBER := OKC_API.G_MISS_NUM
24: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
25: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
26: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
27: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
28: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
31: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
31: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
32: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
33: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
34: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
36: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
37: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
31: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
32: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
33: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
34: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
36: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
37: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
38: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
32: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
33: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
34: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
36: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
37: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
38: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
39: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
35: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
36: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
37: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
38: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
39: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
41: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
42: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
38: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
39: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
40: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
41: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
42: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
46: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
40: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
41: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
42: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
46: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
48: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
46: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
48: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
50: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
43: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
46: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
48: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
50: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
51: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
48: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
50: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
51: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
52: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
53: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
54: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
50: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
51: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
52: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
53: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
54: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
51: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
52: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
53: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
54: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
53: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
54: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68: , object_version_number NUMBER := OKC_API.G_MISS_NUM
61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68: , object_version_number NUMBER := OKC_API.G_MISS_NUM
69: , security_group_id NUMBER := OKC_API.G_MISS_NUM
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68: , object_version_number NUMBER := OKC_API.G_MISS_NUM
69: , security_group_id NUMBER := OKC_API.G_MISS_NUM
70: , request_id NUMBER := OKC_API.G_MISS_NUM
63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
68: , object_version_number NUMBER := OKC_API.G_MISS_NUM
69: , security_group_id NUMBER := OKC_API.G_MISS_NUM
70: , request_id NUMBER := OKC_API.G_MISS_NUM
71: , created_by NUMBER := OKC_API.G_MISS_NUM
68: , object_version_number NUMBER := OKC_API.G_MISS_NUM
69: , security_group_id NUMBER := OKC_API.G_MISS_NUM
70: , request_id NUMBER := OKC_API.G_MISS_NUM
71: , created_by NUMBER := OKC_API.G_MISS_NUM
72: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
70: , request_id NUMBER := OKC_API.G_MISS_NUM
71: , created_by NUMBER := OKC_API.G_MISS_NUM
72: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
72: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
75: , last_update_login NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
83: , accepted_by NUMBER := OKC_API.G_MISS_NUM
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
95: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
95: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
96: G_MISS_khrv_rec khrv_rec_type;
89: , person_party_id NUMBER := OKC_API.G_MISS_NUM
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
95: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
96: G_MISS_khrv_rec khrv_rec_type;
97: TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR
95: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
96: G_MISS_khrv_rec khrv_rec_type;
97: TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
98: INDEX BY BINARY_INTEGER;