83: l_vendor_site_id NUMBER;
84: l_vendor_contact_name VARCHAR2(100);
85: l_org_name VARCHAR2(100);
86: l_msg_count NUMBER;
87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
84: l_vendor_contact_name VARCHAR2(100);
85: l_org_name VARCHAR2(100);
86: l_msg_count NUMBER;
87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
92:
85: l_org_name VARCHAR2(100);
86: l_msg_count NUMBER;
87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
92:
93: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'create_contract';
86: l_msg_count NUMBER;
87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
92:
93: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'create_contract';
94: d_position NUMBER;
87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
92:
93: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'create_contract';
94: d_position NUMBER;
95:
285: l_contr_type VARCHAR2(25);
286: l_rev_number NUMBER;
287: l_doc_num VARCHAR2(100);
288: l_msg_count NUMBER;
289: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
290:
291: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'check_contract_exists';
292: d_position NUMBER;
293:
402: l_contr_type VARCHAR2(25);
403: l_rev_number NUMBER;
404: l_doc_num VARCHAR2(100);
405: l_msg_count NUMBER;
406: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
407:
408: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'get_contract';
409: d_position NUMBER;
410:
755: l_count VARCHAR2(1);
756: l_po_doc_type VARCHAR2(25);
757: l_contr_type VARCHAR2(25);
758: l_rev_number NUMBER;
759: l_doc_rec OKC_IMP_RECORD_TYPES.document_rec_type;
760: l_msg_data VARCHAR2(1000);
761: l_msg_count NUMBER;
762:
763: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || '.' || 'chklist_task_available';
856: l_progress NUMBER := 0;
857: l_result VARCHAR2(50);
858: l_tasklist_result VARCHAR2(50);
859: l_open_mod_fail_type VARCHAR2(20);
860: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
861: l_contr_type VARCHAR2(50);
862: l_type_lookup_code VARCHAR2(50);
863: x_msg_data VARCHAR2(1000);
864: x_msg_count NUMBER;
1301: l_vendor_site_id NUMBER;
1302: l_vendor_contact_id NUMBER;
1303: l_vendor_contact_name VARCHAR2(100);
1304: l_org_name VARCHAR2(100);
1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1302: l_vendor_contact_id NUMBER;
1303: l_vendor_contact_name VARCHAR2(100);
1304: l_org_name VARCHAR2(100);
1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
1303: l_vendor_contact_name VARCHAR2(100);
1304: l_org_name VARCHAR2(100);
1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
1311: l_return_status VARCHAR2(25);
1304: l_org_name VARCHAR2(100);
1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
1311: l_return_status VARCHAR2(25);
1312: l_msg_count NUMBER;
1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
1311: l_return_status VARCHAR2(25);
1312: l_msg_count NUMBER;
1313: l_closeout_doc_count NUMBER;
1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_type;
1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;
1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;
1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;
1311: l_return_status VARCHAR2(25);
1312: l_msg_count NUMBER;
1313: l_closeout_doc_count NUMBER;
1314: l_checklist_req VARCHAR2(25);
1739: l_progress NUMBER := 0;
1740: l_result VARCHAR2(50);
1741: l_tasklist_result VARCHAR2(50);
1742: l_open_mod_fail_type VARCHAR2(20);
1743: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1744: l_contr_type VARCHAR2(50);
1745: l_type_lookup_code VARCHAR2(50);
1746: x_msg_data VARCHAR2(1000);
1747: x_msg_count NUMBER;
2593: , x_return_msg OUT NOCOPY VARCHAR2
2594: )
2595: IS
2596: l_progress NUMBER := 0;
2597: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
2598: l_contract_type VARCHAR2(50);
2599: l_contract_id NUMBER;
2600: l_contract_ver NUMBER;
2601: l_msg_count NUMBER;
3280: ) IS
3281: l_progress NUMBER := 0;
3282: l_document_id NUMBER;
3283:
3284: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
3285: l_msg_data VARCHAR2(1000);
3286: l_msg_count NUMBER;
3287: l_return_status VARCHAR2(100);
3288: l_task_status VARCHAR2(30);