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_REP_CONTRACTS_ALL

Line 27: FROM OKC_REP_CONTRACTS_ALL

23:
24:
25: CURSOR target_contract_csr IS
26: SELECT contract_type, owner_id, contract_number
27: FROM OKC_REP_CONTRACTS_ALL
28: WHERE contract_id = p_target_contract_id;
29:
30: target_contract_rec target_contract_csr%ROWTYPE;
31:

Line 318: FROM okc_rep_contracts_all

314: CLOSE c_get_doc_details;
315:
316: IF x_return_status = 'S' THEN
317: SELECT contract_version_num INTO x_new_version_num
318: FROM okc_rep_contracts_all
319: WHERE contract_id = p_contract_id
320: AND contract_type = p_contract_type;
321: END IF;
322:

Line 424: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

420:
421: CURSOR c_get_doc_details IS
422: SELECT orcu.business_document_type, orcu.business_document_id,
423: orca.contract_effective_date
424: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
425: WHERE orca.contract_id = p_contract_id
426: AND orca.contract_type = orcu.contract_type
427: AND orcu.contract_version = orca.contract_version_num
428: AND orca.contract_id = orcu.contract_id;

Line 602: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

598:
599: CURSOR c_get_doc_details IS
600: SELECT orcu.business_document_type, orcu.business_document_id,
601: orca.contract_effective_date
602: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
603: WHERE orca.contract_id = p_contract_id
604: AND orca.contract_type = orcu.contract_type
605: AND orcu.contract_version = orca.contract_version_num
606: AND orca.contract_id = orcu.contract_id;

Line 853: FROM OKC_REP_CONTRACTS_ALL

849: l_del_status VARCHAR2(15);
850:
851: CURSOR contract_csr(p_contract_type VARCHAR2, p_contract_id NUMBER) IS
852: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
853: FROM OKC_REP_CONTRACTS_ALL
854: WHERE contract_id = p_contract_id
855: AND contract_type = p_contract_type;
856:
857: CURSOR c_get_contract_id_csr IS

Line 865: SELECT DELIVERABLE_STATUS FROM okc_deliverables del, okc_rep_contracts_all orca

861:
862: contract_rec contract_csr%ROWTYPE;
863:
864: CURSOR c_del_status_csr IS
865: SELECT DELIVERABLE_STATUS FROM okc_deliverables del, okc_rep_contracts_all orca
866: WHERE del.BUSINESS_DOCUMENT_TYPE = orca.contract_type
867: AND del.BUSINESS_DOCUMENT_ID = orca.contract_id
868: AND del.BUSINESS_DOCUMENT_VERSION = orca.contract_version_num
869: AND contract_id = l_contract_id

Line 1157: UPDATE okc_rep_contracts_all

1153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1154: 'Updating latest_signed_ver_number column');
1155: END IF;
1156:
1157: UPDATE okc_rep_contracts_all
1158: SET latest_signed_ver_number = contract_rec.contract_version_num ,
1159: contract_effective_date = p_physical_completion_date
1160: WHERE contract_id = l_contract_id;
1161: CLOSE contract_csr;

Line 1816: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orc

1812:
1813: IF (all_dels_completed = 'Y') THEN
1814:
1815: SELECT orcu.business_document_id INTO l_po_header_id
1816: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orc
1817: WHERE orcu.contract_id = l_del_rec.business_document_id
1818: AND orcu.contract_type = l_del_rec.business_document_type
1819: AND orc.contract_id = orcu.contract_id
1820: AND orc.contract_type = orcu.contract_type

Line 1879: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

1875:
1876: CURSOR c_get_doc_details IS
1877: SELECT orcu.contract_type, orcu.contract_id,
1878: orca.contract_effective_date
1879: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
1880: WHERE orcu.business_document_id = p_document_rec.business_document_id
1881: and orcu.business_document_type = p_document_rec.business_document_type
1882: AND orca.contract_type = orcu.contract_type
1883: AND orcu.contract_version = orca.contract_version_num

Line 2126: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

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
2127: WHERE orcu.business_document_id = p_src_document_rec.business_document_id
2128: and orcu.business_document_type = p_src_document_rec.business_document_type
2129: AND orca.contract_type = orcu.contract_type
2130: AND orcu.contract_version = orca.contract_version_num

Line 2135: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

2131: AND orca.contract_id = orcu.contract_id;
2132:
2133: CURSOR c_get_tgt_contract IS
2134: SELECT orcu.contract_id
2135: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
2136: WHERE orcu.business_document_id = p_tgt_document_rec.business_document_id
2137: and orcu.business_document_type = p_tgt_document_rec.business_document_type
2138: AND orca.contract_type = orcu.contract_type
2139: AND orcu.contract_version = orca.contract_version_num