eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_KHR_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

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

Line 9: , chr_id NUMBER := OKC_API.G_MISS_NUM

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

Line 10: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM

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

Line 11: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR

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

Line 12: , cc_no OKS_K_HEADERS_V.CC_NO%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

Line 13: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 14: , cc_bank_acct_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
18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 15: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR

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

Line 16: , commitment_id NUMBER := OKC_API.G_MISS_NUM

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
20: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE

Line 17: , grace_duration NUMBER := OKC_API.G_MISS_NUM

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

Line 18: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

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

Line 19: , est_rev_percent 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
23: , tax_code NUMBER := OKC_API.G_MISS_NUM

Line 20: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 21: , tax_amount 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
25: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

Line 22: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR

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

Line 23: , tax_code NUMBER := OKC_API.G_MISS_NUM

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
27: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 24: , tax_exemption_id 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
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

Line 25: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

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

Line 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

Line 27: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%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
31: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

Line 28: , quote_to_contact_id 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
32: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

Line 29: , quote_to_site_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
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

Line 30: , quote_to_email_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
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

Line 31: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

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

Line 32: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

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

Line 33: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

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

Line 34: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

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

Line 35: , renewal_price_list 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
39: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 36: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

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

Line 37: , renewal_markup_percent 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
41: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

Line 38: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM

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

Line 39: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%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
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

Line 40: , renewal_est_rev_percent 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
44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 41: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

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

Line 42: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR

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

Line 43: , renewal_price_list_used 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
47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 44: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_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

Line 45: , renewal_notification_to 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
49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

Line 46: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR

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

Line 47: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%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
51: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

Line 48: , renewal_markup_percent_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
52: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

Line 49: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

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

Line 50: , rev_est_duration_used 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
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

Line 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

Line 52: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

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
56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

Line 53: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%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

Line 54: , evn_threshold_amt 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
58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

Line 55: , evn_threshold_cur OKS_K_HEADERS_V.EVN_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

Line 56: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

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
60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 57: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%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

Line 58: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

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
62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR

Line 59: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%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

Line 60: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%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

Line 61: , inv_print_profile OKS_K_HEADERS_V.INV_PRINT_PROFILE%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

Line 62: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%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

Line 63: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%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

Line 64: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%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

Line 65: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%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
69: , security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 66: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%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
70: , request_id NUMBER := OKC_API.G_MISS_NUM

Line 67: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%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
71: , created_by NUMBER := OKC_API.G_MISS_NUM

Line 68: , object_version_number NUMBER := OKC_API.G_MISS_NUM

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
72: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 69: , security_group_id NUMBER := OKC_API.G_MISS_NUM

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

Line 70: , request_id NUMBER := OKC_API.G_MISS_NUM

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

Line 71: , created_by NUMBER := OKC_API.G_MISS_NUM

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

Line 72: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 73: , last_updated_by 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
77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR

Line 74: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 75: , last_update_login 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
79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR

Line 76: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%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

Line 77: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR

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

Line 78: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR

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

Line 79: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR

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

Line 80: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 81: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM

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
85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 82: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE

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

Line 83: , accepted_by NUMBER := OKC_API.G_MISS_NUM

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
87: , process_request_id NUMBER := OKC_API.G_MISS_NUM

Line 84: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_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

Line 85: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%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

Line 86: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

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

Line 87: , process_request_id NUMBER := OKC_API.G_MISS_NUM

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
91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 88: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%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

Line 89: , person_party_id NUMBER := OKC_API.G_MISS_NUM

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
93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 90: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_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

Line 91: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%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*/

Line 92: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

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;

Line 93: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%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;
97: TYPE khrv_tbl_type IS TABLE OF khrv_rec_type

Line 94: , renewal_comment OKS_K_HEADERS_V.RENEWAL_COMMENT%TYPE := OKC_API.G_MISS_CHAR

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;

Line 95: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /Added for ER 13869562/

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;
99: -- OKS_K_HEADERS_B Record Spec

Line 101: id NUMBER := OKC_API.G_MISS_NUM

97: TYPE khrv_tbl_type IS TABLE OF khrv_rec_type
98: INDEX BY BINARY_INTEGER;
99: -- OKS_K_HEADERS_B Record Spec
100: TYPE khr_rec_type IS RECORD (
101: id NUMBER := OKC_API.G_MISS_NUM
102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR

Line 102: , chr_id NUMBER := OKC_API.G_MISS_NUM

98: INDEX BY BINARY_INTEGER;
99: -- OKS_K_HEADERS_B Record Spec
100: TYPE khr_rec_type IS RECORD (
101: id NUMBER := OKC_API.G_MISS_NUM
102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE

Line 103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM

99: -- OKS_K_HEADERS_B Record Spec
100: TYPE khr_rec_type IS RECORD (
101: id NUMBER := OKC_API.G_MISS_NUM
102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM

Line 104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR

100: TYPE khr_rec_type IS RECORD (
101: id NUMBER := OKC_API.G_MISS_NUM
102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR

101: id NUMBER := OKC_API.G_MISS_NUM
102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM

Line 106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE

102: , chr_id NUMBER := OKC_API.G_MISS_NUM
103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM

Line 107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM

103: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR

104: , payment_type OKS_K_HEADERS_B.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM

Line 109: , commitment_id NUMBER := OKC_API.G_MISS_NUM

105: , cc_no OKS_K_HEADERS_B.CC_NO%TYPE := OKC_API.G_MISS_CHAR
106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE

Line 110: , grace_duration NUMBER := OKC_API.G_MISS_NUM

106: , cc_expiry_date OKS_K_HEADERS_B.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM

Line 111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

107: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM

108: , cc_auth_code OKS_K_HEADERS_B.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM

Line 113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE

109: , commitment_id NUMBER := OKC_API.G_MISS_NUM
110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM

Line 114: , tax_amount NUMBER := OKC_API.G_MISS_NUM

110: , grace_duration NUMBER := OKC_API.G_MISS_NUM
111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

Line 115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR

111: , grace_period OKS_K_HEADERS_B.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 116: , tax_code NUMBER := OKC_API.G_MISS_NUM

112: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM

113: , est_rev_date OKS_K_HEADERS_B.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM

Line 118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

114: , tax_amount NUMBER := OKC_API.G_MISS_NUM
115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM

Line 119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR

115: , tax_status OKS_K_HEADERS_B.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM

Line 120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR

116: , tax_code NUMBER := OKC_API.G_MISS_NUM
117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

Line 121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM

117: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

Line 122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM

118: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

Line 123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM

119: , renewal_status OKS_K_HEADERS_B.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

120: , electronic_renewal_flag OKS_K_HEADERS_B.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM

Line 125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

121: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

122: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM

Line 127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

123: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM

Line 128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM

124: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

125: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM

Line 130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM

126: , renewal_po_required OKS_K_HEADERS_B.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

Line 131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM

127: , renewal_po_number OKS_K_HEADERS_B.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

128: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM

Line 133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM

129: , renewal_pricing_type OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

130: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM

Line 135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR

131: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR

Line 136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM

132: , renewal_grace_period OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

133: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM

Line 138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM

134: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

Line 139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR

135: , renewal_est_rev_period OKS_K_HEADERS_B.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM

Line 140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

136: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

Line 141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM

137: , renewal_type_used OKS_K_HEADERS_B.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

Line 142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

138: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM

Line 143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM

139: , renewal_po_used OKS_K_HEADERS_B.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

Line 144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

140: , renewal_pricing_type_used OKS_K_HEADERS_B.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

Line 145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

141: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

Line 146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM

142: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

Line 147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

143: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

Line 148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

144: , rev_est_period_used OKS_K_HEADERS_B.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

145: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR

Line 150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

146: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR

Line 151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

147: , evn_threshold_cur OKS_K_HEADERS_B.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR

Line 152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR

148: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR

Line 153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR

149: , ern_threshold_cur OKS_K_HEADERS_B.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR

150: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

Line 155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR

151: , renewal_grace_period_used OKS_K_HEADERS_B.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR

152: , inv_trx_type OKS_K_HEADERS_B.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

153: , inv_print_profile OKS_K_HEADERS_B.INV_PRINT_PROFILE%TYPE := OKC_API.G_MISS_CHAR
154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM

Line 158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

154: , ar_interface_yn OKS_K_HEADERS_B.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM

Line 159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR

155: , hold_billing OKS_K_HEADERS_B.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 160: , object_version_number NUMBER := OKC_API.G_MISS_NUM

156: , summary_trx_yn OKS_K_HEADERS_B.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 161: , request_id NUMBER := OKC_API.G_MISS_NUM

157: , service_po_number OKS_K_HEADERS_B.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 162: , created_by NUMBER := OKC_API.G_MISS_NUM

158: , service_po_required OKS_K_HEADERS_B.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

159: , billing_schedule_type OKS_K_HEADERS_B.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

160: , object_version_number NUMBER := OKC_API.G_MISS_NUM
161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR

Line 165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

161: , request_id NUMBER := OKC_API.G_MISS_NUM
162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE

Line 166: , last_update_login NUMBER := OKC_API.G_MISS_NUM

162: , created_by NUMBER := OKC_API.G_MISS_NUM
163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM

Line 167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR

163: , creation_date OKS_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE

Line 168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR

164: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM

Line 169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE

165: , last_update_date OKS_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM

166: , last_update_login NUMBER := OKC_API.G_MISS_NUM
167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE

167: , ern_flag_used_yn OKS_K_HEADERS_B.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 172: , accepted_by NUMBER := OKC_API.G_MISS_NUM

168: , follow_up_action OKS_K_HEADERS_B.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM

Line 173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

169: , follow_up_date OKS_K_HEADERS_B.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR

Line 174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

170: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR

Line 175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

171: , date_accepted OKS_K_HEADERS_B.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 176: , process_request_id NUMBER := OKC_API.G_MISS_NUM

172: , accepted_by NUMBER := OKC_API.G_MISS_NUM
173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR

Line 177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR

173: , rmndr_suppress_flag OKS_K_HEADERS_B.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM

Line 178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR

174: , rmndr_sent_flag OKS_K_HEADERS_B.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR

175: , quote_sent_flag OKS_K_HEADERS_B.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR

176: , process_request_id NUMBER := OKC_API.G_MISS_NUM
177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 181: , person_party_id NUMBER := OKC_API.G_MISS_NUM

177: , wf_item_key OKS_K_HEADERS_B.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR

178: , period_start OKS_K_HEADERS_B.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR

Line 183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

179: , period_type OKS_K_HEADERS_B.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/

Line 184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

180: , price_uom OKS_K_HEADERS_B.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
188: G_MISS_khr_rec khr_rec_type;

Line 185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

181: , person_party_id NUMBER := OKC_API.G_MISS_NUM
182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
188: G_MISS_khr_rec khr_rec_type;
189: TYPE khr_tbl_type IS TABLE OF khr_rec_type

Line 186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR

182: , tax_classification_code OKS_K_HEADERS_B.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
188: G_MISS_khr_rec khr_rec_type;
189: TYPE khr_tbl_type IS TABLE OF khr_rec_type
190: INDEX BY BINARY_INTEGER;

Line 187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /Added for ER 13869562/

183: , exempt_certificate_number OKS_K_HEADERS_B.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
184: , exempt_reason_code OKS_K_HEADERS_B.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
185: , approval_type_used OKS_K_HEADERS_B.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
186: , renewal_comment OKS_K_HEADERS_B.renewal_comment%TYPE := OKC_API.G_MISS_CHAR
187: , cc_email_address OKS_K_HEADERS_B.CC_EMAIl_ADDRESS%TYPE := OKC_API.G_MISS_CHAR); /*Added for ER 13869562*/
188: G_MISS_khr_rec khr_rec_type;
189: TYPE khr_tbl_type IS TABLE OF khr_rec_type
190: INDEX BY BINARY_INTEGER;
191: ---------------------------------------------------------------------------

Line 194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

190: INDEX BY BINARY_INTEGER;
191: ---------------------------------------------------------------------------
192: -- GLOBAL MESSAGE CONSTANTS
193: ---------------------------------------------------------------------------
194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

191: ---------------------------------------------------------------------------
192: -- GLOBAL MESSAGE CONSTANTS
193: ---------------------------------------------------------------------------
194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

192: -- GLOBAL MESSAGE CONSTANTS
193: ---------------------------------------------------------------------------
194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

193: ---------------------------------------------------------------------------
194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

194: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

195: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

196: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
204: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';

Line 201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

197: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
204: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
205: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

198: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
204: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
205: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
206: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

199: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
200: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
201: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
202: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
203: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
204: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
205: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
206: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
207:

Line 217: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

213: ---------------------------------------------------------------------------
214: -- GLOBAL VARIABLES
215: ---------------------------------------------------------------------------
216: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_KHR_PVT';
217: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
218: ---------------------------------------------------------------------------
219: -- Procedures and Functions
220: ---------------------------------------------------------------------------
221:

Line 241: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_khrv_tbl IN khrv_tbl_type,
240: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
241: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
242: PROCEDURE insert_row(
243: p_api_version IN NUMBER,
244: p_init_msg_list IN VARCHAR2,
245: x_return_status OUT NOCOPY VARCHAR2,

Line 264: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

260: x_return_status OUT NOCOPY VARCHAR2,
261: x_msg_count OUT NOCOPY NUMBER,
262: x_msg_data OUT NOCOPY VARCHAR2,
263: p_khrv_tbl IN khrv_tbl_type,
264: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
265: PROCEDURE lock_row(
266: p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2,
268: x_return_status OUT NOCOPY VARCHAR2,

Line 288: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

284: x_msg_count OUT NOCOPY NUMBER,
285: x_msg_data OUT NOCOPY VARCHAR2,
286: p_khrv_tbl IN khrv_tbl_type,
287: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
288: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
289: PROCEDURE update_row(
290: p_api_version IN NUMBER,
291: p_init_msg_list IN VARCHAR2,
292: x_return_status OUT NOCOPY VARCHAR2,

Line 311: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

307: x_return_status OUT NOCOPY VARCHAR2,
308: x_msg_count OUT NOCOPY NUMBER,
309: x_msg_data OUT NOCOPY VARCHAR2,
310: p_khrv_tbl IN khrv_tbl_type,
311: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
312: PROCEDURE delete_row(
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2,
315: x_return_status OUT NOCOPY VARCHAR2,

Line 333: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2,
332: p_khrv_tbl IN khrv_tbl_type,
333: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
334: PROCEDURE validate_row(
335: p_api_version IN NUMBER,
336: p_init_msg_list IN VARCHAR2,
337: x_return_status OUT NOCOPY VARCHAR2,