eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_CLOSEOUT_PVT dependencies on OKC_IMP_RECORD_TYPES

Line 236: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

232: l_api_name VARCHAR2(30);
233: l_api_version NUMBER;
234: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
235:
236: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
237:
238: CURSOR c_get_doc_details IS
239: SELECT business_document_type, business_document_id
240: FROM okc_rep_contract_usages

Line 419: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

415: l_api_version NUMBER;
416: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
417: l_physical_completion_date DATE;
418: l_task_status VARCHAR2(30);
419: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
420:
421: CURSOR c_get_doc_details IS
422: SELECT orcu.business_document_type, orcu.business_document_id,
423: orca.contract_effective_date

Line 594: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

590: l_api_version NUMBER;
591: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
592: l_error_found Boolean := FALSE;
593: l_warning_found Boolean := FALSE;
594: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
595: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;
596: l_sequence_id NUMBER;
597: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
598:

Line 829: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

825: END validate_closeout_tasks;
826:
827:
828: PROCEDURE Activate_tasks_closeout(p_api_version IN NUMBER,
829: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
830: p_physical_completion_date IN DATE ,
831: p_init_msg_list IN VARCHAR2,
832: p_commit IN VARCHAR2,
833: x_task_status OUT NOCOPY VARCHAR2,

Line 1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1259: END Activate_tasks_closeout;
1260:
1261:
1262: Procedure create_contract(p_api_version IN NUMBER,
1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

1260:
1261:
1262: Procedure create_contract(p_api_version IN NUMBER,
1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1268: p_commit IN VARCHAR2 := fnd_api.g_false,

Line 1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

1261:
1262: Procedure create_contract(p_api_version IN NUMBER,
1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1268: p_commit IN VARCHAR2 := fnd_api.g_false,
1269: x_msg_data OUT NOCOPY VARCHAR2,

Line 1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

1262: Procedure create_contract(p_api_version IN NUMBER,
1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1268: p_commit IN VARCHAR2 := fnd_api.g_false,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: x_msg_count OUT NOCOPY NUMBER,

Line 1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

1263: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1264: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
1265: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
1266: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
1267: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
1268: p_commit IN VARCHAR2 := fnd_api.g_false,
1269: x_msg_data OUT NOCOPY VARCHAR2,
1270: x_msg_count OUT NOCOPY NUMBER,
1271: x_return_status OUT NOCOPY VARCHAR2

Line 1281: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

1277: l_auto_num_profile VARCHAR2(1);
1278: l_auto_number_yn VARCHAR2(1);
1279: l_auto_number_option CONSTANT VARCHAR2(30):= 'OKC_REP_AUTO_CON_NUMBER';
1280:
1281: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1282:
1283: BEGIN
1284: l_api_name := 'create_contract';
1285:

Line 1416: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1412: Deletes the Contract for the given document type.
1413: */
1414:
1415: Procedure delete_contract(p_api_version IN NUMBER,
1416: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1417: p_contract_type IN VARCHAR2 DEFAULT NULL,
1418: p_contract_id IN NUMBER DEFAULT NULL,
1419: p_commit IN VARCHAR2 := fnd_api.g_false,
1420: x_msg_data OUT NOCOPY VARCHAR2,

Line 1526: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1522: The relation of parent document which is obtained in p_document_rec is stored in the okc_rep_contract_usages table
1523: */
1524:
1525: Procedure create_new_contract_version(p_api_version IN NUMBER,
1526: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1527: p_contract_type IN VARCHAR2 DEFAULT NULL,
1528: p_contract_id IN NUMBER DEFAULT NULL,
1529: p_commit IN VARCHAR2 := fnd_api.g_false,
1530: x_msg_data OUT NOCOPY VARCHAR2,

Line 1643: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1639:
1640: END create_new_contract_version;
1641:
1642: PROCEDURE check_contract_exists(p_api_version IN NUMBER,
1643: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1644: x_contract_type IN OUT NOCOPY VARCHAR2 ,
1645: x_contract_id IN OUT NOCOPY NUMBER ,
1646: x_contract_version_num IN OUT NOCOPY NUMBER,
1647: x_msg_data OUT NOCOPY VARCHAR2,

Line 1858: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

1854:
1855: PROCEDURE validate_closeout_tasks(p_api_version IN NUMBER,
1856: p_init_msg_list IN VARCHAR2,
1857: p_commit IN VARCHAR2,
1858: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
1859: x_msg_data OUT NOCOPY VARCHAR2,
1860: x_msg_count OUT NOCOPY NUMBER,
1861: x_return_status OUT NOCOPY VARCHAR2,
1862: x_qa_return_status OUT NOCOPY VARCHAR2,

Line 1871: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

1867: l_api_version NUMBER;
1868: l_internal_party_id OKC_REP_CONTRACT_PARTIES.PARTY_ID%TYPE;
1869: l_error_found Boolean := FALSE;
1870: l_warning_found Boolean := FALSE;
1871: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
1872: l_bus_doc_date_events_tbl OKC_TERMS_QA_GRP.BUSDOCDATES_TBL_TYPE;
1873: l_sequence_id NUMBER;
1874: l_qa_result_tbl OKC_TERMS_QA_PVT.qa_result_tbl_type;
1875:

Line 2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2098:
2099: PROCEDURE copy_set_tasks_to_each_po(p_api_version IN NUMBER,
2100: p_init_msg_list IN VARCHAR2,
2101: p_commit IN VARCHAR2,
2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

Line 2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2099: PROCEDURE copy_set_tasks_to_each_po(p_api_version IN NUMBER,
2100: p_init_msg_list IN VARCHAR2,
2101: p_commit IN VARCHAR2,
2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

Line 2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,

2100: p_init_msg_list IN VARCHAR2,
2101: p_commit IN VARCHAR2,
2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
2108: x_msg_data OUT NOCOPY VARCHAR2,

Line 2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,

2101: p_commit IN VARCHAR2,
2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
2108: x_msg_data OUT NOCOPY VARCHAR2,
2109: x_msg_count OUT NOCOPY NUMBER,

Line 2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,

2102: p_src_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
2108: x_msg_data OUT NOCOPY VARCHAR2,
2109: x_msg_count OUT NOCOPY NUMBER,
2110: x_return_status OUT NOCOPY VARCHAR2)

Line 2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,

2103: p_tgt_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2104: p_contract_rec IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_rec_type,
2105: p_contract_parties_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_parties_tbl_type,
2106: p_party_contacts_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.party_contacts_tbl_type,
2107: p_risks_tbl IN OUT NOCOPY OKC_IMP_RECORD_TYPES.contract_risks_tbl_type,
2108: x_msg_data OUT NOCOPY VARCHAR2,
2109: x_msg_count OUT NOCOPY NUMBER,
2110: x_return_status OUT NOCOPY VARCHAR2)
2111: IS

Line 2122: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;

2118: l_auto_num_profile VARCHAR2(1);
2119: l_auto_number_yn VARCHAR2(1);
2120: l_auto_number_option CONSTANT VARCHAR2(30):= 'OKC_REP_AUTO_CON_NUMBER';
2121:
2122: l_document_rec OKC_IMP_RECORD_TYPES.document_rec_type;
2123:
2124: CURSOR c_get_src_contract IS
2125: SELECT orcu.contract_id
2126: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

Line 2370: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,

2366: END copy_set_tasks_to_each_po;
2367:
2368: PROCEDURE check_tasks_exists(p_api_version IN NUMBER,
2369: p_init_msg_list IN VARCHAR2,
2370: p_document_rec IN OKC_IMP_RECORD_TYPES.document_rec_type,
2371: x_del_count OUT NOCOPY NUMBER,
2372: x_msg_data OUT NOCOPY VARCHAR2,
2373: x_msg_count OUT NOCOPY NUMBER,
2374: x_return_status OUT NOCOPY VARCHAR2)