DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on OKC_IMP_RECORD_TYPES

Line 87: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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;

Line 88: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_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:

Line 89: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_type;

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

Line 90: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;

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;

Line 91: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;

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:

Line 289: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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:

Line 406: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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:

Line 759: l_doc_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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

Line 860: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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;

Line 1305: l_src_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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;

Line 1306: l_tgt_document_rec OKC_IMP_RECORD_TYPES.document_rec_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;

Line 1307: l_contract_rec OKC_IMP_RECORD_TYPES.contract_rec_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);

Line 1308: l_contract_parties OKC_IMP_RECORD_TYPES.contract_parties_tbl_type;

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;

Line 1309: l_risks_tbl OKC_IMP_RECORD_TYPES.contract_risks_tbl_type;

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;

Line 1310: l_party_contacts OKC_IMP_RECORD_TYPES.party_contacts_tbl_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;
1314: l_checklist_req VARCHAR2(25);

Line 1743: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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;

Line 2597: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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;

Line 3284: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

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