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_CONTRACT_IMP_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 633: SELECT contract_status_code FROM okc_rep_contracts_all

629:
630: l_contract_status VARCHAR2(30);
631:
632: CURSOR c_get_contract_status IS
633: SELECT contract_status_code FROM okc_rep_contracts_all
634: WHERE contract_id = p_contract_id;
635:
636: BEGIN
637: l_api_name := 'delete_contract ';

Line 1332: FROM okc_rep_contracts_all orca

1328: --populate p_contract_rec
1329: SELECT contract_type, contract_id, contract_version_num, run_id
1330: INTO l_contract_rec.contract_type, l_contract_rec.contract_id,
1331: l_contract_rec.contract_version_num, l_contract_rec.run_id
1332: FROM okc_rep_contracts_all orca
1333: WHERE contract_id = l_contract_id;
1334:
1335: --Call the original delete API to delete the conract
1336: delete_contract(p_api_version => p_api_version,

Line 1477: SELECT contract_status_code FROM okc_rep_contracts_all

1473: l_error_code VARCHAR2(20);
1474: l_error_msg VARCHAR2(2000);
1475:
1476: CURSOR c_get_contract_status IS
1477: SELECT contract_status_code FROM okc_rep_contracts_all
1478: WHERE contract_id = p_contract_id;
1479:
1480:
1481: BEGIN

Line 1503: -- OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details API copies the record from okc_rep_contracts_all

1499: CLOSE c_get_contract_status;
1500:
1501: IF l_contract_status IN ('SIGNED', 'APPROVED', 'CANCELLED') THEN
1502:
1503: -- OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details API copies the record from okc_rep_contracts_all
1504: -- table to okc_rep_contract_vers table and versions Terms, Deliverables, Attachments and UDA's
1505: OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details(p_api_version => p_api_version,
1506: p_init_msg_list => fnd_api.g_false,
1507: p_commit => p_commit,

Line 1514: --update the version and status of the record in okc_rep_contracts_all

1510: x_msg_data => x_msg_data,
1511: x_msg_count => x_msg_count,
1512: x_return_status => x_return_status);
1513:
1514: --update the version and status of the record in okc_rep_contracts_all
1515: UPDATE okc_rep_contracts_all SET contract_version_num = contract_version_num +1,
1516: contract_status_code = 'DRAFT',
1517: last_updated_by = FND_GLOBAL.user_id(),
1518: last_update_login = FND_GLOBAL.user_id(),

Line 1515: UPDATE okc_rep_contracts_all SET contract_version_num = contract_version_num +1,

1511: x_msg_count => x_msg_count,
1512: x_return_status => x_return_status);
1513:
1514: --update the version and status of the record in okc_rep_contracts_all
1515: UPDATE okc_rep_contracts_all SET contract_version_num = contract_version_num +1,
1516: contract_status_code = 'DRAFT',
1517: last_updated_by = FND_GLOBAL.user_id(),
1518: last_update_login = FND_GLOBAL.user_id(),
1519: last_update_date = SYSDATE,

Line 1737: FROM okc_rep_contracts_all orca

1733: --populate p_contract_rec
1734: SELECT contract_type, contract_id, contract_version_num, run_id
1735: INTO l_contract_rec.contract_type, l_contract_rec.contract_id,
1736: l_contract_rec.contract_version_num, l_contract_rec.run_id
1737: FROM okc_rep_contracts_all orca
1738: WHERE contract_id = l_contract_id;
1739:
1740: Update_contract_usages(p_api_version => p_api_version,
1741: p_contract_rec => l_contract_rec,

Line 1797: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

1793: l_api_version CONSTANT NUMBER := 1.0;
1794:
1795: CURSOR c_contract_exist_csr IS
1796: SELECT orcu.contract_type, orcu.contract_id, orcu.contract_version
1797: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
1798: WHERE orcu.business_document_type = p_document_rec.business_document_type
1799: AND orcu.business_document_id = p_document_rec.business_document_id
1800: --AND orcu.business_document_version = p_document_rec.business_document_version
1801: AND orcu.contract_type = Nvl(x_contract_type,orcu.contract_type)

Line 1865: FROM OKC_REP_CONTRACTS_ALL

1861: l_contract_id NUMBER;
1862:
1863: CURSOR contract_csr(p_contract_type VARCHAR2, p_contract_id NUMBER) IS
1864: SELECT contract_type, contract_version_num, latest_signed_ver_number, contract_effective_date, contract_expiration_date
1865: FROM OKC_REP_CONTRACTS_ALL
1866: WHERE contract_id = p_contract_id
1867: AND contract_type = p_contract_type;
1868:
1869: CURSOR c_get_contract_id_csr IS

Line 2157: UPDATE okc_rep_contracts_all

2153: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2154: 'Updating latest_signed_ver_number column');
2155: END IF;
2156:
2157: UPDATE okc_rep_contracts_all
2158: SET latest_signed_ver_number = contract_rec.contract_version_num
2159: WHERE contract_id = l_contract_id;
2160: CLOSE contract_csr;
2161:

Line 2260: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca

2256:
2257: CURSOR c_contract_exist_csr IS
2258: SELECT orcu.contract_type, orcu.contract_id, orcu.contract_version, orca.contract_status_code ,
2259: orca.sbcr_coordination_type
2260: FROM okc_rep_contract_usages orcu, okc_rep_contracts_all orca
2261: WHERE orcu.business_document_type = p_document_rec.business_document_type
2262: AND orcu.business_document_id = p_document_rec.business_document_id
2263: --AND orcu.business_document_version = p_document_rec.business_document_version
2264: AND orcu.contract_type = Nvl(x_contract_rec.contract_type,orcu.contract_type)

Line 2404: FROM okc_rep_contracts_all WHERE contract_id = l_contract_id;

2400: FETCH c_contract_id_cur INTO l_contract_id, l_contract_version_num;
2401: exit when c_contract_id_cur%notfound;
2402:
2403: SELECT contract_status_code INTO l_contract_status_code
2404: FROM okc_rep_contracts_all WHERE contract_id = l_contract_id;
2405:
2406: IF (l_contract_status_code = 'DRAFT' AND l_contract_version_num = 1) THEN
2407: --populate p_contract_rec
2408: SELECT contract_type, contract_id, contract_version_num, run_id

Line 2411: FROM okc_rep_contracts_all orca

2407: --populate p_contract_rec
2408: SELECT contract_type, contract_id, contract_version_num, run_id
2409: INTO l_contract_rec.contract_type, l_contract_rec.contract_id,
2410: l_contract_rec.contract_version_num, l_contract_rec.run_id
2411: FROM okc_rep_contracts_all orca
2412: WHERE contract_id = l_contract_id;
2413:
2414: --Call the original delete API to delete the conract
2415: delete_contract(p_api_version => p_api_version,

Line 2533: SELECT contract_type, contract_status_code FROM okc_rep_contracts_all

2529: l_contract_type VARCHAR2(30);
2530: l_resolved_msg_name VARCHAR2(30);
2531:
2532: CURSOR c_get_contract_status IS
2533: SELECT contract_type, contract_status_code FROM okc_rep_contracts_all
2534: WHERE contract_id = p_contract_id;
2535:
2536: BEGIN
2537: l_api_name := 'cancel_contract ';

Line 2583: UPDATE okc_rep_contracts_all

2579: RAISE OKC_API.G_EXCEPTION_ERROR;
2580: END IF;
2581: --------------------------------------------------------
2582: --Change Contract status TO CANCELLED
2583: UPDATE okc_rep_contracts_all
2584: SET CONTRACT_STATUS_CODE = 'CANCELLED',
2585: CANCELLATION_DATE = SYSDATE
2586: WHERE contract_id = p_contract_id
2587: AND contract_type = l_contract_type;

Line 2914: okc_rep_contracts_all src,

2910: rels.last_updated_by,
2911: rels.last_update_date,
2912: rels.last_update_login
2913: FROM okc_rep_contract_rels rels,
2914: okc_rep_contracts_all src,
2915: okc_rep_contracts_all tgt
2916: WHERE src.contract_id = rels.contract_id
2917: AND tgt.contract_id = rels.related_contract_id
2918: --to avoid reruns of this procedure or on abnormal run of this program

Line 2915: okc_rep_contracts_all tgt

2911: rels.last_update_date,
2912: rels.last_update_login
2913: FROM okc_rep_contract_rels rels,
2914: okc_rep_contracts_all src,
2915: okc_rep_contracts_all tgt
2916: WHERE src.contract_id = rels.contract_id
2917: AND tgt.contract_id = rels.related_contract_id
2918: --to avoid reruns of this procedure or on abnormal run of this program
2919: AND NOT EXISTS (SELECT 1 FROM okc_rep_contract_usages new_rels

Line 2944: okc_rep_contracts_all tgt

2940: rels.last_update_date,
2941: rels.last_update_login
2942: FROM okc_rep_contract_rels rels,
2943: okc_rep_contract_vers src_vers,
2944: okc_rep_contracts_all tgt
2945: WHERE src_vers.contract_id = rels.contract_id
2946: AND tgt.contract_id = rels.related_contract_id
2947: --to avoid reruns of this procedure or on abnormal run of this program
2948: AND NOT EXISTS (SELECT 1 FROM okc_rep_contract_usages new_rels

Line 2982: FROM okc_rep_contract_rels rels, okc_rep_contracts_all con

2978: SELECT count(1) INTO l_source_rels
2979: FROM okc_rep_contract_rels;
2980:
2981: SELECT sum(con.contract_version_num) INTO l_source_rows
2982: FROM okc_rep_contract_rels rels, okc_rep_contracts_all con
2983: WHERE rels.contract_id = con.contract_id;
2984:
2985: SELECT count(1) INTO l_already_migrated
2986: FROM okc_rep_contract_usages usages