1: PACKAGE okl_okc_migration_pvt AUTHID CURRENT_USER AS
2: /* $Header: OKLROKCS.pls 120.2 2006/11/13 07:34:05 dpsingh noship $ */
3: -- The Enities we are Handling are as listed below
4: --1.OKC_K_VERS_NUMBERS_V -- cvmv
5: --2.OKC_K_HEADERS_V -- chrv
6: --3.OKC_K_LINES_V -- clev
7: --4.OKC_K_ITEMS_V -- cimv
8: --5.OKC_K_PARTY_ROLES_V -- cplv
9: --6.OKC_GOVERNANCES_V -- gvev
28:
29: TYPE chrv_rec_type IS RECORD (
30: id NUMBER := OKC_API.G_MISS_NUM,
31: object_version_number NUMBER := OKC_API.G_MISS_NUM,
32: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
33: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
34: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
35: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
36: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
33: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
34: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
35: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
36: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
37: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
38: qcl_id NUMBER := OKC_API.G_MISS_NUM,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
35: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
36: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
37: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
38: qcl_id NUMBER := OKC_API.G_MISS_NUM,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
36: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
37: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
38: qcl_id NUMBER := OKC_API.G_MISS_NUM,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
37: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
38: qcl_id NUMBER := OKC_API.G_MISS_NUM,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
38: qcl_id NUMBER := OKC_API.G_MISS_NUM,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
39: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
40: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
41: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
42: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
43: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
44: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
45: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
46: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
47: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
48: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
49: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
50: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
51: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
52: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
53: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
54: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
55: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
56: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
57: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
58: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
59: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
60: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
61: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
62: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
63: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
64: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
65: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
66: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
67: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
68: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
69: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
70: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
78: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
71: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
72: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
78: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
79: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
73: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
78: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
79: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
80: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
81: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
74: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
75: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
76: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
77: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
78: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
79: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
80: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
81: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
82: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
78: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
79: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
80: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
81: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
82: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
83: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
84: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
85: application_id NUMBER := OKC_API.G_MISS_NUM,
86: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
79: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
80: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
81: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
82: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
83: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
84: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
85: application_id NUMBER := OKC_API.G_MISS_NUM,
86: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
82: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
83: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
84: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
85: application_id NUMBER := OKC_API.G_MISS_NUM,
86: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
88: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
89: program_id NUMBER := OKC_API.G_MISS_NUM,
90: request_id NUMBER := OKC_API.G_MISS_NUM,
84: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
85: application_id NUMBER := OKC_API.G_MISS_NUM,
86: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
87: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
88: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
89: program_id NUMBER := OKC_API.G_MISS_NUM,
90: request_id NUMBER := OKC_API.G_MISS_NUM,
91: price_list_id NUMBER := OKC_API.G_MISS_NUM,
92: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
88: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
89: program_id NUMBER := OKC_API.G_MISS_NUM,
90: request_id NUMBER := OKC_API.G_MISS_NUM,
91: price_list_id NUMBER := OKC_API.G_MISS_NUM,
92: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
93: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
94: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
89: program_id NUMBER := OKC_API.G_MISS_NUM,
90: request_id NUMBER := OKC_API.G_MISS_NUM,
91: price_list_id NUMBER := OKC_API.G_MISS_NUM,
92: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
93: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
94: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
90: request_id NUMBER := OKC_API.G_MISS_NUM,
91: price_list_id NUMBER := OKC_API.G_MISS_NUM,
92: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
93: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
94: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
94: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
95: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
95: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
96: program_application_id NUMBER := OKC_API.G_MISS_NUM,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
97: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
98: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
99: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
100: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
101: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
102: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
103: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
104: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
105: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
106: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
107: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
108: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
109: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
110: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
111: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
112: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_update_login NUMBER := OKC_API.G_MISS_NUM,
119: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
113: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
114: created_by NUMBER := OKC_API.G_MISS_NUM,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_update_login NUMBER := OKC_API.G_MISS_NUM,
119: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
120: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
121: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
115: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_update_login NUMBER := OKC_API.G_MISS_NUM,
119: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
120: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
121: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
122: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
123: --new columns to replace rules
116: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
117: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
118: last_update_login NUMBER := OKC_API.G_MISS_NUM,
119: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
120: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
121: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
122: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
123: --new columns to replace rules
124: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,