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_CONTRACT_HDR_PUB dependencies on OKC_API

Line 5: id NUMBER := OKC_API.G_MISS_NUM

1: PACKAGE oks_contract_hdr_pub AS
2: /* $Header: OKSPKHRS.pls 120.3 2005/08/04 16:05:36 anjkumar noship $ */
3: -- OKS_K_HEADERS_HV Record Spec
4: TYPE khrhv_rec_type IS RECORD (
5: id NUMBER := OKC_API.G_MISS_NUM
6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 6: , major_version NUMBER := OKC_API.G_MISS_NUM

2: /* $Header: OKSPKHRS.pls 120.3 2005/08/04 16:05:36 anjkumar noship $ */
3: -- OKS_K_HEADERS_HV Record Spec
4: TYPE khrhv_rec_type IS RECORD (
5: id NUMBER := OKC_API.G_MISS_NUM
6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR

Line 7: , chr_id NUMBER := OKC_API.G_MISS_NUM

3: -- OKS_K_HEADERS_HV Record Spec
4: TYPE khrhv_rec_type IS RECORD (
5: id NUMBER := OKC_API.G_MISS_NUM
6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE

Line 8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM

4: TYPE khrhv_rec_type IS RECORD (
5: id NUMBER := OKC_API.G_MISS_NUM
6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM

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

5: id NUMBER := OKC_API.G_MISS_NUM
6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR

6: , major_version NUMBER := OKC_API.G_MISS_NUM
7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM

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

7: , chr_id NUMBER := OKC_API.G_MISS_NUM
8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM

Line 12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM

8: , acct_rule_id NUMBER := OKC_API.G_MISS_NUM
9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

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

9: , payment_type OKS_K_HEADERS_V.PAYMENT_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM

Line 14: , commitment_id NUMBER := OKC_API.G_MISS_NUM

10: , cc_no OKS_K_HEADERS_V.CC_NO%TYPE := OKC_API.G_MISS_CHAR
11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE

Line 15: , grace_duration NUMBER := OKC_API.G_MISS_NUM

11: , cc_expiry_date OKS_K_HEADERS_V.CC_EXPIRY_DATE%TYPE := OKC_API.G_MISS_DATE
12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM

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

12: , cc_bank_acct_id NUMBER := OKC_API.G_MISS_NUM
13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM

13: , cc_auth_code OKS_K_HEADERS_V.CC_AUTH_CODE%TYPE := OKC_API.G_MISS_CHAR
14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM

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

14: , commitment_id NUMBER := OKC_API.G_MISS_NUM
15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM

Line 19: , tax_amount NUMBER := OKC_API.G_MISS_NUM

15: , grace_duration NUMBER := OKC_API.G_MISS_NUM
16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

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

16: , grace_period OKS_K_HEADERS_V.GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 21: , tax_code NUMBER := OKC_API.G_MISS_NUM

17: , est_rev_percent NUMBER := OKC_API.G_MISS_NUM
18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM

18: , est_rev_date OKS_K_HEADERS_V.EST_REV_DATE%TYPE := OKC_API.G_MISS_DATE
19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM

Line 23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM

19: , tax_amount NUMBER := OKC_API.G_MISS_NUM
20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM

Line 24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR

20: , tax_status OKS_K_HEADERS_V.TAX_STATUS%TYPE := OKC_API.G_MISS_CHAR
21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM

Line 25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR

21: , tax_code NUMBER := OKC_API.G_MISS_NUM
22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

Line 26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM

22: , tax_exemption_id NUMBER := OKC_API.G_MISS_NUM
23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

Line 27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM

23: , billing_profile_id NUMBER := OKC_API.G_MISS_NUM
24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

Line 28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM

24: , renewal_status OKS_K_HEADERS_V.RENEWAL_STATUS%TYPE := OKC_API.G_MISS_CHAR
25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM

25: , electronic_renewal_flag OKS_K_HEADERS_V.ELECTRONIC_RENEWAL_FLAG%TYPE := OKC_API.G_MISS_CHAR
26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM

Line 30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM

26: , quote_to_contact_id NUMBER := OKC_API.G_MISS_NUM
27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR

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

27: , quote_to_site_id NUMBER := OKC_API.G_MISS_NUM
28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM

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

28: , quote_to_email_id NUMBER := OKC_API.G_MISS_NUM
29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM

Line 33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM

29: , quote_to_phone_id NUMBER := OKC_API.G_MISS_NUM
30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

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

30: , quote_to_fax_id NUMBER := OKC_API.G_MISS_NUM
31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM

Line 35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM

31: , renewal_po_required OKS_K_HEADERS_V.RENEWAL_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

Line 36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM

32: , renewal_po_number OKS_K_HEADERS_V.RENEWAL_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR

Line 37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR

33: , renewal_price_list NUMBER := OKC_API.G_MISS_NUM
34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM

Line 38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM

34: , renewal_pricing_type OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE%TYPE := OKC_API.G_MISS_CHAR
35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM

35: , renewal_markup_percent NUMBER := OKC_API.G_MISS_NUM
36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM

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

36: , renewal_grace_duration NUMBER := OKC_API.G_MISS_NUM
37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR

Line 41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM

37: , renewal_grace_period OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD%TYPE := OKC_API.G_MISS_CHAR
38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

Line 42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

38: , renewal_est_rev_percent NUMBER := OKC_API.G_MISS_NUM
39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM

Line 43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM

39: , renewal_est_rev_duration NUMBER := OKC_API.G_MISS_NUM
40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

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

40: , renewal_est_rev_period OKS_K_HEADERS_V.RENEWAL_EST_REV_PERIOD%TYPE := OKC_API.G_MISS_CHAR
41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM

Line 45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR

41: , renewal_price_list_used NUMBER := OKC_API.G_MISS_NUM
42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

Line 46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM

42: , renewal_type_used OKS_K_HEADERS_V.RENEWAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

Line 47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM

43: , renewal_notification_to NUMBER := OKC_API.G_MISS_NUM
44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR

Line 48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM

44: , renewal_po_used OKS_K_HEADERS_V.RENEWAL_PO_USED%TYPE := OKC_API.G_MISS_CHAR
45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM

Line 49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

45: , renewal_pricing_type_used OKS_K_HEADERS_V.RENEWAL_PRICING_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR
46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

Line 50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM

46: , renewal_markup_percent_used NUMBER := OKC_API.G_MISS_NUM
47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

Line 51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR

47: , rev_est_percent_used NUMBER := OKC_API.G_MISS_NUM
48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

Line 52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM

48: , rev_est_duration_used NUMBER := OKC_API.G_MISS_NUM
49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

Line 53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

49: , rev_est_period_used OKS_K_HEADERS_V.REV_EST_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

Line 54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM

50: , billing_profile_used NUMBER := OKC_API.G_MISS_NUM
51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR

51: , ern_flag_used_yn OKS_K_HEADERS_V.ERN_FLAG_USED_YN%TYPE := OKC_API.G_MISS_CHAR
52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR

Line 56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM

52: , evn_threshold_amt NUMBER := OKC_API.G_MISS_NUM
53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR

Line 57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR

53: , evn_threshold_cur OKS_K_HEADERS_V.EVN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR

Line 58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR

54: , ern_threshold_amt NUMBER := OKC_API.G_MISS_NUM
55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR

Line 59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR

55: , ern_threshold_cur OKS_K_HEADERS_V.ERN_THRESHOLD_CUR%TYPE := OKC_API.G_MISS_CHAR
56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR

56: , renewal_grace_duration_used NUMBER := OKC_API.G_MISS_NUM
57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

Line 61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR

57: , renewal_grace_period_used OKS_K_HEADERS_V.RENEWAL_GRACE_PERIOD_USED%TYPE := OKC_API.G_MISS_CHAR
58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR

58: , inv_trx_type OKS_K_HEADERS_V.INV_TRX_TYPE%TYPE := OKC_API.G_MISS_CHAR
59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR

59: , inv_print_profile OKS_K_HEADERS_V.inv_print_profile%TYPE := OKC_API.G_MISS_CHAR
60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR

60: , ar_interface_yn OKS_K_HEADERS_V.AR_INTERFACE_YN%TYPE := OKC_API.G_MISS_CHAR
61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM

Line 65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR

61: , hold_billing OKS_K_HEADERS_V.HOLD_BILLING%TYPE := OKC_API.G_MISS_CHAR
62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM

Line 66: , object_version_number NUMBER := OKC_API.G_MISS_NUM

62: , summary_trx_yn OKS_K_HEADERS_V.SUMMARY_TRX_YN%TYPE := OKC_API.G_MISS_CHAR
63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 67: , security_group_id NUMBER := OKC_API.G_MISS_NUM

63: , service_po_number OKS_K_HEADERS_V.SERVICE_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR
64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 68: , request_id NUMBER := OKC_API.G_MISS_NUM

64: , service_po_required OKS_K_HEADERS_V.SERVICE_PO_REQUIRED%TYPE := OKC_API.G_MISS_CHAR
65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 69: , created_by NUMBER := OKC_API.G_MISS_NUM

65: , billing_schedule_type OKS_K_HEADERS_V.BILLING_SCHEDULE_TYPE%TYPE := OKC_API.G_MISS_CHAR
66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM

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

66: , object_version_number NUMBER := OKC_API.G_MISS_NUM
67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR

Line 71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM

67: , security_group_id NUMBER := OKC_API.G_MISS_NUM
68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR

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

68: , request_id NUMBER := OKC_API.G_MISS_NUM
69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR

Line 73: , last_update_login NUMBER := OKC_API.G_MISS_NUM

69: , created_by NUMBER := OKC_API.G_MISS_NUM
70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR

Line 74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR

70: , creation_date OKS_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE

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

71: , last_updated_by NUMBER := OKC_API.G_MISS_NUM
72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM

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

72: , last_update_date OKS_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE

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

73: , last_update_login NUMBER := OKC_API.G_MISS_NUM
74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM

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

74: , period_type OKS_K_HEADERS_V.PERIOD_TYPE%TYPE := OKC_API.G_MISS_CHAR
75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM

75: , period_start OKS_K_HEADERS_V.PERIOD_START%TYPE := OKC_API.G_MISS_CHAR
76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

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

76: , price_uom OKS_K_HEADERS_V.PRICE_UOM%TYPE := OKC_API.G_MISS_CHAR
77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 81: , accepted_by NUMBER := OKC_API.G_MISS_NUM

77: , follow_up_action OKS_K_HEADERS_V.FOLLOW_UP_ACTION%TYPE := OKC_API.G_MISS_CHAR
78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM

Line 82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR

78: , follow_up_date OKS_K_HEADERS_V.FOLLOW_UP_DATE%TYPE := OKC_API.G_MISS_DATE
79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR

Line 83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR

79: , trxn_extension_id NUMBER := OKC_API.G_MISS_NUM
80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM

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

80: , date_accepted OKS_K_HEADERS_V.DATE_ACCEPTED%TYPE := OKC_API.G_MISS_DATE
81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 85: , process_request_id NUMBER := OKC_API.G_MISS_NUM

81: , accepted_by NUMBER := OKC_API.G_MISS_NUM
82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

Line 86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR

82: , rmndr_suppress_flag OKS_K_HEADERS_V.RMNDR_SUPPRESS_FLAG%TYPE := OKC_API.G_MISS_CHAR
83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 87: , person_party_id NUMBER := OKC_API.G_MISS_NUM

83: , rmndr_sent_flag OKS_K_HEADERS_V.RMNDR_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );

Line 88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR

84: , quote_sent_flag OKS_K_HEADERS_V.QUOTE_SENT_FLAG%TYPE := OKC_API.G_MISS_CHAR
85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
92: G_MISS_khrhv_rec khrhv_rec_type;

Line 89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR

85: , process_request_id NUMBER := OKC_API.G_MISS_NUM
86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
92: G_MISS_khrhv_rec khrhv_rec_type;
93: TYPE khrhv_tbl_type IS TABLE OF khrhv_rec_type

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

86: , wf_item_key OKS_K_HEADERS_V.WF_ITEM_KEY%TYPE := OKC_API.G_MISS_CHAR
87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
92: G_MISS_khrhv_rec khrhv_rec_type;
93: TYPE khrhv_tbl_type IS TABLE OF khrhv_rec_type
94: INDEX BY BINARY_INTEGER;

Line 91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );

87: , person_party_id NUMBER := OKC_API.G_MISS_NUM
88: , tax_classification_code OKS_K_HEADERS_V.TAX_CLASSIFICATION_CODE%TYPE := OKC_API.G_MISS_CHAR
89: , exempt_certificate_number OKS_K_HEADERS_V.EXEMPT_CERTIFICATE_NUMBER%TYPE := OKC_API.G_MISS_CHAR
90: , exempt_reason_code OKS_K_HEADERS_V.EXEMPT_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
91: , approval_type_used OKS_K_HEADERS_V.APPROVAL_TYPE_USED%TYPE := OKC_API.G_MISS_CHAR );
92: G_MISS_khrhv_rec khrhv_rec_type;
93: TYPE khrhv_tbl_type IS TABLE OF khrhv_rec_type
94: INDEX BY BINARY_INTEGER;
95:

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

98: ---------------------------------------------------------------------------
99: -- GLOBAL VARIABLES
100: ---------------------------------------------------------------------------
101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
104: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

Line 103: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;

99: -- GLOBAL VARIABLES
100: ---------------------------------------------------------------------------
101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
104: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 104: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;

100: ---------------------------------------------------------------------------
101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
104: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;

101: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_HDR_PUB';
102: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
103: G_RET_STS_SUCCESS CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_SUCCESS;
104: G_RET_STS_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_ERROR;
105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
109: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;

Line 109: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;

105: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(20) := OKC_API.G_RET_STS_UNEXP_ERROR;
106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
109: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
110: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
111: ---------------------------------------------------------------------------
112:
113: PROCEDURE create_header(

Line 110: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;

106: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
107: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
108: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
109: G_FALSE CONSTANT VARCHAR2(10) := OKC_API.G_FALSE;
110: G_TRUE CONSTANT VARCHAR2(10) := OKC_API.G_TRUE;
111: ---------------------------------------------------------------------------
112:
113: PROCEDURE create_header(
114: p_api_version IN NUMBER,

Line 130: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_khrv_tbl IN khrv_tbl_type,
129: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
130: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
131: p_validate_yn IN VARCHAR2);
132: PROCEDURE create_header(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2,

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

151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_khrv_tbl IN khrv_tbl_type,
155: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
156: PROCEDURE lock_header(
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2,
159: x_return_status OUT NOCOPY VARCHAR2,

Line 180: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,

176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_khrv_tbl IN khrv_tbl_type,
179: x_khrv_tbl OUT NOCOPY khrv_tbl_type,
180: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE,
181: p_validate_yn IN VARCHAR2);
182: PROCEDURE update_header(
183: p_api_version IN NUMBER,
184: p_init_msg_list IN VARCHAR2,

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

201: x_return_status OUT NOCOPY VARCHAR2,
202: x_msg_count OUT NOCOPY NUMBER,
203: x_msg_data OUT NOCOPY VARCHAR2,
204: p_khrv_tbl IN khrv_tbl_type,
205: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
206: PROCEDURE delete_header(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2,
209: x_return_status OUT NOCOPY VARCHAR2,

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

223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_khrv_tbl IN khrv_tbl_type,
227: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
228: PROCEDURE validate_header(
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2,
231: x_return_status OUT NOCOPY VARCHAR2,