3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE chr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: TYPE chr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
5: ---------------------------------------------------------------------------
6: TYPE chr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
6: TYPE chr_rec_type IS RECORD (
7: id NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
7: id NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
8: contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
9: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
10: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
11: contract_number_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
12: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
13: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
14: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
15: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
16: sts_code OKC_K_HEADERS_B.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
17: qcl_id NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
18: scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
19: trn_code OKC_K_HEADERS_B.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
20: currency_code OKC_K_HEADERS_B.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
21: archived_yn OKC_K_HEADERS_B.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
22: deleted_yn OKC_K_HEADERS_B.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
23: template_yn OKC_K_HEADERS_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
24: chr_type OKC_K_HEADERS_B.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
25: object_version_number NUMBER := OKC_API.G_MISS_NUM,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
26: created_by NUMBER := OKC_API.G_MISS_NUM,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
27: creation_date OKC_K_HEADERS_B.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
28: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
29: last_update_date OKC_K_HEADERS_B.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
30: cust_po_number_req_yn OKC_K_HEADERS_B.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
31: pre_pay_req_yn OKC_K_HEADERS_B.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
32: cust_po_number OKC_K_HEADERS_B.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
33: dpas_rating OKC_K_HEADERS_B.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
34: template_used OKC_K_HEADERS_B.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
35: date_approved OKC_K_HEADERS_B.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
36: datetime_cancelled OKC_K_HEADERS_B.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
37: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
38: date_issued OKC_K_HEADERS_B.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
39: datetime_responded OKC_K_HEADERS_B.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
40: rfp_type OKC_K_HEADERS_B.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
41: keep_on_mail_list OKC_K_HEADERS_B.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
42: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
43: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
44: date_close_projected OKC_K_HEADERS_B.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
45: datetime_proposed OKC_K_HEADERS_B.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
46: date_signed OKC_K_HEADERS_B.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
47: date_terminated OKC_K_HEADERS_B.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
48: date_renewed OKC_K_HEADERS_B.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
49: start_date OKC_K_HEADERS_B.START_DATE%TYPE := OKC_API.G_MISS_DATE,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
50: end_date OKC_K_HEADERS_B.END_DATE%TYPE := OKC_API.G_MISS_DATE,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
51: buy_or_sell OKC_K_HEADERS_B.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
52: issue_or_receive OKC_K_HEADERS_B.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
53: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
54: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
55: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
56: currency_code_renewed OKC_K_HEADERS_B.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
57: last_update_login NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
58: upg_orig_system_ref OKC_K_HEADERS_B.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
59: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
60: application_id NUMBER := OKC_API.G_MISS_NUM,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
61: orig_system_source_code OKC_K_HEADERS_B.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
62: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
63: orig_system_reference1 OKC_K_HEADERS_B.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
64: program_id NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
65: request_id NUMBER := OKC_API.G_MISS_NUM,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
66: price_list_id NUMBER := OKC_API.G_MISS_NUM,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
67: pricing_date OKC_K_HEADERS_B.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
68: sign_by_date OKC_K_HEADERS_B.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
69: program_update_date OKC_K_HEADERS_B.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
70: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
71: program_application_id NUMBER := OKC_API.G_MISS_NUM,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
72: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
73: GOVERNING_CONTRACT_YN OKC_K_HEADERS_B.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
74: attribute_category OKC_K_HEADERS_B.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
75: attribute1 OKC_K_HEADERS_B.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
76: attribute2 OKC_K_HEADERS_B.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
77: attribute3 OKC_K_HEADERS_B.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
78: attribute4 OKC_K_HEADERS_B.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
79: attribute5 OKC_K_HEADERS_B.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
80: attribute6 OKC_K_HEADERS_B.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
81: attribute7 OKC_K_HEADERS_B.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
82: attribute8 OKC_K_HEADERS_B.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
83: attribute9 OKC_K_HEADERS_B.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
84: attribute10 OKC_K_HEADERS_B.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
85: attribute11 OKC_K_HEADERS_B.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
86: attribute12 OKC_K_HEADERS_B.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
87: attribute13 OKC_K_HEADERS_B.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
88: attribute14 OKC_K_HEADERS_B.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
89: attribute15 OKC_K_HEADERS_B.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
90: --new columns to replace rules
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
91: conversion_type OKC_K_HEADERS_B.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
92: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
93: conversion_rate_date OKC_K_HEADERS_B.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
94: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
95: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
96: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
97: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
98: renewal_type_code OKC_K_HEADERS_B.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
99: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
100: renewal_end_date OKC_K_HEADERS_B.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
101: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109: -- R12 Data Model Changes 4485150 End
102: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109: -- R12 Data Model Changes 4485150 End
110: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
103: document_id NUMBER :=OKC_API.G_MISS_NUM,
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109: -- R12 Data Model Changes 4485150 End
110: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
111: billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE
104: -- R12 Data Model Changes 4485150 start
105: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109: -- R12 Data Model Changes 4485150 End
110: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
111: billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE
112: );
106: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
107: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
108: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
109: -- R12 Data Model Changes 4485150 End
110: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
111: billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE
112: );
113: g_miss_chr_rec chr_rec_type;
114: TYPE chr_tbl_type IS TABLE OF chr_rec_type
114: TYPE chr_tbl_type IS TABLE OF chr_rec_type
115: INDEX BY BINARY_INTEGER;
116:
117: TYPE okc_k_headers_tl_rec_type IS RECORD (
118: id NUMBER := OKC_API.G_MISS_NUM,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
115: INDEX BY BINARY_INTEGER;
116:
117: TYPE okc_k_headers_tl_rec_type IS RECORD (
118: id NUMBER := OKC_API.G_MISS_NUM,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
116:
117: TYPE okc_k_headers_tl_rec_type IS RECORD (
118: id NUMBER := OKC_API.G_MISS_NUM,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
117: TYPE okc_k_headers_tl_rec_type IS RECORD (
118: id NUMBER := OKC_API.G_MISS_NUM,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
118: id NUMBER := OKC_API.G_MISS_NUM,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
119: language OKC_K_HEADERS_TL.LANGUAGE%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
120: source_lang OKC_K_HEADERS_TL.SOURCE_LANG%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
121: sfwt_flag OKC_K_HEADERS_TL.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
122: short_description OKC_K_HEADERS_TL.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
123: comments OKC_K_HEADERS_TL.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
124: description OKC_K_HEADERS_TL.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
125: cognomen OKC_K_HEADERS_TL.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM);
126: non_response_reason OKC_K_HEADERS_TL.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM);
134: g_miss_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
127: non_response_explain OKC_K_HEADERS_TL.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM);
134: g_miss_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
135: TYPE okc_k_headers_tl_tbl_type IS TABLE OF okc_k_headers_tl_rec_type
128: set_aside_reason OKC_K_HEADERS_TL.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM);
134: g_miss_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
135: TYPE okc_k_headers_tl_tbl_type IS TABLE OF okc_k_headers_tl_rec_type
136: INDEX BY BINARY_INTEGER;
129: created_by NUMBER := OKC_API.G_MISS_NUM,
130: creation_date OKC_K_HEADERS_TL.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
131: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
132: last_update_date OKC_K_HEADERS_TL.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
133: last_update_login NUMBER := OKC_API.G_MISS_NUM);
134: g_miss_okc_k_headers_tl_rec okc_k_headers_tl_rec_type;
135: TYPE okc_k_headers_tl_tbl_type IS TABLE OF okc_k_headers_tl_rec_type
136: INDEX BY BINARY_INTEGER;
137:
135: TYPE okc_k_headers_tl_tbl_type IS TABLE OF okc_k_headers_tl_rec_type
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE chrv_rec_type IS RECORD (
139: id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE chrv_rec_type IS RECORD (
139: id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
137:
138: TYPE chrv_rec_type IS RECORD (
139: id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
138: TYPE chrv_rec_type IS RECORD (
139: id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
139: id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
140: object_version_number NUMBER := OKC_API.G_MISS_NUM,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
141: sfwt_flag OKC_K_HEADERS_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
142: chr_id_response NUMBER := OKC_API.G_MISS_NUM,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
143: chr_id_award NUMBER := OKC_API.G_MISS_NUM,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
144: chr_id_renewed NUMBER := OKC_API.G_MISS_NUM,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
145: INV_ORGANIZATION_ID NUMBER := OKC_API.G_MISS_NUM,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
146: sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
147: qcl_id NUMBER := OKC_API.G_MISS_NUM,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
148: scs_code OKC_K_HEADERS_V.SCS_CODE%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
149: contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
150: currency_code OKC_K_HEADERS_V.CURRENCY_CODE%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
151: contract_number_modifier OKC_K_HEADERS_V.CONTRACT_NUMBER_MODIFIER%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
152: archived_yn OKC_K_HEADERS_V.ARCHIVED_YN%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
153: deleted_yn OKC_K_HEADERS_V.DELETED_YN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
154: cust_po_number_req_yn OKC_K_HEADERS_V.CUST_PO_NUMBER_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
155: pre_pay_req_yn OKC_K_HEADERS_V.PRE_PAY_REQ_YN%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
156: cust_po_number OKC_K_HEADERS_V.CUST_PO_NUMBER%TYPE := OKC_API.G_MISS_CHAR,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
157: short_description OKC_K_HEADERS_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
158: comments OKC_K_HEADERS_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
159: description OKC_K_HEADERS_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
160: dpas_rating OKC_K_HEADERS_V.DPAS_RATING%TYPE := OKC_API.G_MISS_CHAR,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
161: cognomen OKC_K_HEADERS_V.COGNOMEN%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
162: template_yn OKC_K_HEADERS_V.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
163: template_used OKC_K_HEADERS_V.TEMPLATE_USED%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
164: date_approved OKC_K_HEADERS_V.DATE_APPROVED%TYPE := OKC_API.G_MISS_DATE,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
165: datetime_cancelled OKC_K_HEADERS_V.DATETIME_CANCELLED%TYPE := OKC_API.G_MISS_DATE,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
166: auto_renew_days NUMBER := OKC_API.G_MISS_NUM,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
167: date_issued OKC_K_HEADERS_V.DATE_ISSUED%TYPE := OKC_API.G_MISS_DATE,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
168: datetime_responded OKC_K_HEADERS_V.DATETIME_RESPONDED%TYPE := OKC_API.G_MISS_DATE,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
169: non_response_reason OKC_K_HEADERS_V.NON_RESPONSE_REASON%TYPE := OKC_API.G_MISS_CHAR,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
170: non_response_explain OKC_K_HEADERS_V.NON_RESPONSE_EXPLAIN%TYPE := OKC_API.G_MISS_CHAR,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
171: rfp_type OKC_K_HEADERS_V.RFP_TYPE%TYPE := OKC_API.G_MISS_CHAR,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
172: chr_type OKC_K_HEADERS_V.CHR_TYPE%TYPE := OKC_API.G_MISS_CHAR,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
173: keep_on_mail_list OKC_K_HEADERS_V.KEEP_ON_MAIL_LIST%TYPE := OKC_API.G_MISS_CHAR,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
174: set_aside_reason OKC_K_HEADERS_V.SET_ASIDE_REASON%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
175: set_aside_percent NUMBER := OKC_API.G_MISS_NUM,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
176: response_copies_req NUMBER := OKC_API.G_MISS_NUM,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
177: date_close_projected OKC_K_HEADERS_V.DATE_CLOSE_PROJECTED%TYPE := OKC_API.G_MISS_DATE,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
178: datetime_proposed OKC_K_HEADERS_V.DATETIME_PROPOSED%TYPE := OKC_API.G_MISS_DATE,
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
179: date_signed OKC_K_HEADERS_V.DATE_SIGNED%TYPE := OKC_API.G_MISS_DATE,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
180: date_terminated OKC_K_HEADERS_V.DATE_TERMINATED%TYPE := OKC_API.G_MISS_DATE,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
181: date_renewed OKC_K_HEADERS_V.DATE_RENEWED%TYPE := OKC_API.G_MISS_DATE,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
182: trn_code OKC_K_HEADERS_V.TRN_CODE%TYPE := OKC_API.G_MISS_CHAR,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
183: start_date OKC_K_HEADERS_V.START_DATE%TYPE := OKC_API.G_MISS_DATE,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
184: end_date OKC_K_HEADERS_V.END_DATE%TYPE := OKC_API.G_MISS_DATE,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
185: authoring_org_id NUMBER := OKC_API.G_MISS_NUM,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
186: -- org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
187: buy_or_sell OKC_K_HEADERS_V.BUY_OR_SELL%TYPE := OKC_API.G_MISS_CHAR,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
188: issue_or_receive OKC_K_HEADERS_V.ISSUE_OR_RECEIVE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
189: estimated_amount NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
190: chr_id_renewed_to NUMBER := OKC_API.G_MISS_NUM,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
191: estimated_amount_renewed NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
192: currency_code_renewed OKC_K_HEADERS_V.CURRENCY_CODE_RENEWED%TYPE := OKC_API.G_MISS_CHAR,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
193: upg_orig_system_ref OKC_K_HEADERS_V.UPG_ORIG_SYSTEM_REF%TYPE := OKC_API.G_MISS_CHAR,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
194: upg_orig_system_ref_id NUMBER := OKC_API.G_MISS_NUM,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
195: application_id NUMBER := OKC_API.G_MISS_NUM,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
196: orig_system_source_code OKC_K_HEADERS_V.ORIG_SYSTEM_SOURCE_CODE%TYPE := OKC_API.G_MISS_CHAR,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
197: orig_system_id1 NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
198: orig_system_reference1 OKC_K_HEADERS_V.ORIG_SYSTEM_REFERENCE1%TYPE := OKC_API.G_MISS_CHAR,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
199: program_id NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
200: request_id NUMBER := OKC_API.G_MISS_NUM,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
201: price_list_id NUMBER := OKC_API.G_MISS_NUM,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
202: pricing_date OKC_K_HEADERS_V.PRICING_DATE%TYPE := OKC_API.G_MISS_DATE,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
203: sign_by_date OKC_K_HEADERS_V.SIGN_BY_DATE%TYPE := OKC_API.G_MISS_DATE,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
204: program_update_date OKC_K_HEADERS_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
205: total_line_list_price NUMBER := OKC_API.G_MISS_NUM,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
206: program_application_id NUMBER := OKC_API.G_MISS_NUM,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
207: USER_ESTIMATED_AMOUNT NUMBER := OKC_API.G_MISS_NUM,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
208: GOVERNING_CONTRACT_YN OKC_K_HEADERS_V.GOVERNING_CONTRACT_YN%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
209: attribute_category OKC_K_HEADERS_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
210: attribute1 OKC_K_HEADERS_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
211: attribute2 OKC_K_HEADERS_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
212: attribute3 OKC_K_HEADERS_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
213: attribute4 OKC_K_HEADERS_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
214: attribute5 OKC_K_HEADERS_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
215: attribute6 OKC_K_HEADERS_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
216: attribute7 OKC_K_HEADERS_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
217: attribute8 OKC_K_HEADERS_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
218: attribute9 OKC_K_HEADERS_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
219: attribute10 OKC_K_HEADERS_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
220: attribute11 OKC_K_HEADERS_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
221: attribute12 OKC_K_HEADERS_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
222: attribute13 OKC_K_HEADERS_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
223: attribute14 OKC_K_HEADERS_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
224: attribute15 OKC_K_HEADERS_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
225: created_by NUMBER := OKC_API.G_MISS_NUM,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
226: creation_date OKC_K_HEADERS_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
227: last_updated_by NUMBER := OKC_API.G_MISS_NUM,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
228: last_update_date OKC_K_HEADERS_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
229: last_update_login NUMBER := OKC_API.G_MISS_NUM,
230: old_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
231: new_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE := OKC_API.G_MISS_CHAR,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
232: old_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
233: new_ste_code OKC_STATUSES_V.STE_CODE%TYPE := OKC_API.G_MISS_CHAR ,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
234: --new columns to replace rules
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
235: conversion_type OKC_K_HEADERS_V.CONVERSION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
236: conversion_rate NUMBER := OKC_API.G_MISS_NUM,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
237: conversion_rate_date OKC_K_HEADERS_V.CONVERSION_RATE_DATE%TYPE := OKC_API.G_MISS_DATE,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
238: conversion_euro_rate NUMBER := OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
239: cust_acct_id NUMBER := OKC_API.G_MISS_NUM,
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
240: bill_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
241: inv_rule_id NUMBER := OKC_API.G_MISS_NUM,
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
242: renewal_type_code OKC_K_HEADERS_V.RENEWAL_TYPE_CODE%TYPE :=OKC_API.G_MISS_CHAR,
243: renewal_notify_to NUMBER :=OKC_API.G_MISS_NUM,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
244: renewal_end_date OKC_K_HEADERS_V.RENEWAL_END_DATE%TYPE :=OKC_API.G_MISS_DATE,
245: ship_to_site_use_id NUMBER := OKC_API.G_MISS_NUM,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
246: payment_term_id NUMBER :=OKC_API.G_MISS_NUM,
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254: -- R12 Data Model Changes 4485150 End
247: VALIDATE_YN VARCHAR2(1) DEFAULT 'Y', --Bug#3150149.
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254: -- R12 Data Model Changes 4485150 End
255: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
248: document_id NUMBER :=OKC_API.G_MISS_NUM,
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254: -- R12 Data Model Changes 4485150 End
255: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
256: billed_at_source OKC_K_HEADERS_ALL_V.BILLED_AT_SOURCE%TYPE
249: -- R12 Data Model Changes 4485150 Start
250: approval_type OKC_K_HEADERS_B.APPROVAL_TYPE%TYPE := OKC_API.G_MISS_CHAR,
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254: -- R12 Data Model Changes 4485150 End
255: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
256: billed_at_source OKC_K_HEADERS_ALL_V.BILLED_AT_SOURCE%TYPE
257: );
251: term_cancel_source OKC_K_HEADERS_B.TERM_CANCEL_SOURCE%TYPE := OKC_API.G_MISS_CHAR,
252: payment_instruction_type OKC_K_HEADERS_B.PAYMENT_INSTRUCTION_TYPE%TYPE := OKC_API.G_MISS_CHAR,
253: org_id NUMBER := OKC_API.G_MISS_NUM, --mmadhavi added for MOAC
254: -- R12 Data Model Changes 4485150 End
255: cancelled_amount NUMBER := OKC_API.G_MISS_NUM, -- LLC
256: billed_at_source OKC_K_HEADERS_ALL_V.BILLED_AT_SOURCE%TYPE
257: );
258: g_miss_chrv_rec chrv_rec_type;
259: TYPE chrv_tbl_type IS TABLE OF chrv_rec_type
260: INDEX BY BINARY_INTEGER;
261: ---------------------------------------------------------------------------
262: -- GLOBAL MESSAGE CONSTANTS
263: ---------------------------------------------------------------------------
264: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
261: ---------------------------------------------------------------------------
262: -- GLOBAL MESSAGE CONSTANTS
263: ---------------------------------------------------------------------------
264: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
262: -- GLOBAL MESSAGE CONSTANTS
263: ---------------------------------------------------------------------------
264: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
263: ---------------------------------------------------------------------------
264: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
264: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
265: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
266: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
274: ---------------------------------------------------------------------------
267: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
274: ---------------------------------------------------------------------------
275: -- GLOBAL VARIABLES
268: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
274: ---------------------------------------------------------------------------
275: -- GLOBAL VARIABLES
276: ---------------------------------------------------------------------------
269: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
270: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
271: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
272: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
273: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
274: ---------------------------------------------------------------------------
275: -- GLOBAL VARIABLES
276: ---------------------------------------------------------------------------
277: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHR_PVT';
274: ---------------------------------------------------------------------------
275: -- GLOBAL VARIABLES
276: ---------------------------------------------------------------------------
277: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CHR_PVT';
278: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
279: ---------------------------------------------------------------------------
280: -- Procedures and Functions
281: ---------------------------------------------------------------------------
282:
285: PROCEDURE api_copy;
286: PROCEDURE add_language;
287: PROCEDURE insert_row(
288: p_api_version IN NUMBER,
289: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2,
293: p_chrv_rec IN chrv_rec_type,
294: x_chrv_rec OUT NOCOPY chrv_rec_type);
295:
296: PROCEDURE insert_row(
297: p_api_version IN NUMBER,
298: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_chrv_tbl IN chrv_tbl_type,
303: x_chrv_tbl OUT NOCOPY chrv_tbl_type);
304:
305: PROCEDURE lock_row(
306: p_api_version IN NUMBER,
307: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_chrv_rec IN chrv_rec_type);
311: p_chrv_rec IN chrv_rec_type);
312:
313: PROCEDURE lock_row(
314: p_api_version IN NUMBER,
315: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_chrv_tbl IN chrv_tbl_type);
319: p_chrv_tbl IN chrv_tbl_type);
320:
321: PROCEDURE update_row(
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328: p_chrv_rec IN chrv_rec_type,
329: x_chrv_rec OUT NOCOPY chrv_rec_type);
330:
331: PROCEDURE update_row(
329: x_chrv_rec OUT NOCOPY chrv_rec_type);
330:
331: PROCEDURE update_row(
332: p_api_version IN NUMBER,
333: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
334: x_return_status OUT NOCOPY VARCHAR2,
335: x_msg_count OUT NOCOPY NUMBER,
336: x_msg_data OUT NOCOPY VARCHAR2,
337: p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
338: p_chrv_tbl IN chrv_tbl_type,
339: x_chrv_tbl OUT NOCOPY chrv_tbl_type);
340:
341: PROCEDURE delete_row(
339: x_chrv_tbl OUT NOCOPY chrv_tbl_type);
340:
341: PROCEDURE delete_row(
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344: x_return_status OUT NOCOPY VARCHAR2,
345: x_msg_count OUT NOCOPY NUMBER,
346: x_msg_data OUT NOCOPY VARCHAR2,
347: p_chrv_rec IN chrv_rec_type);
347: p_chrv_rec IN chrv_rec_type);
348:
349: PROCEDURE delete_row(
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352: x_return_status OUT NOCOPY VARCHAR2,
353: x_msg_count OUT NOCOPY NUMBER,
354: x_msg_data OUT NOCOPY VARCHAR2,
355: p_chrv_tbl IN chrv_tbl_type);
355: p_chrv_tbl IN chrv_tbl_type);
356:
357: PROCEDURE validate_row(
358: p_api_version IN NUMBER,
359: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
360: x_return_status OUT NOCOPY VARCHAR2,
361: x_msg_count OUT NOCOPY NUMBER,
362: x_msg_data OUT NOCOPY VARCHAR2,
363: p_chrv_rec IN chrv_rec_type);
363: p_chrv_rec IN chrv_rec_type);
364:
365: PROCEDURE validate_row(
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368: x_return_status OUT NOCOPY VARCHAR2,
369: x_msg_count OUT NOCOPY NUMBER,
370: x_msg_data OUT NOCOPY VARCHAR2,
371: p_chrv_tbl IN chrv_tbl_type);