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_UTIL_PVT dependencies on FND_LOOKUPS

Line 3411: FROM FND_LOOKUPS fnd, OKC_REP_IMP_CONTRACTS_T con

3407: AND bus_doc.document_type_class = 'REPOSITORY';
3408:
3409: CURSOR c_get_contract_status(p_imp_contract_id NUMBER) IS
3410: SELECT LOOKUP_CODE
3411: FROM FND_LOOKUPS fnd, OKC_REP_IMP_CONTRACTS_T con
3412: WHERE con.imp_contract_id = p_imp_contract_id
3413: AND fnd.LOOKUP_TYPE = 'OKC_REP_CONTRACT_STATUSES'
3414: AND fnd.LOOKUP_CODE IN ('SIGNED', 'APPROVED', 'DRAFT')
3415: AND UPPER(fnd.MEANING) = UPPER(con.CONTRACT_STATUS_TXT);

Line 4039: SELECT LOOKUP_CODE FROM FND_LOOKUPS

4035:
4036: l_import_contracts_rec IMPORT_CONTRACTS_CSR%ROWTYPE;
4037:
4038: CURSOR CONTRACT_STATUS_CSR (p_status_txt VARCHAR2) IS
4039: SELECT LOOKUP_CODE FROM FND_LOOKUPS
4040: WHERE LOOKUP_TYPE = 'OKC_REP_CONTRACT_STATUSES'
4041: AND LOOKUP_CODE IN ('SIGNED')
4042: AND UPPER(MEANING) = UPPER(p_status_txt);
4043:

Line 4045: SELECT LOOKUP_CODE FROM FND_LOOKUPS

4041: AND LOOKUP_CODE IN ('SIGNED')
4042: AND UPPER(MEANING) = UPPER(p_status_txt);
4043:
4044: CURSOR CONTRACT_STATUS_CSR_SQL (p_status_txt VARCHAR2) IS
4045: SELECT LOOKUP_CODE FROM FND_LOOKUPS
4046: WHERE LOOKUP_TYPE = 'OKC_REP_CONTRACT_STATUSES'
4047: AND LOOKUP_CODE IN ('SIGNED', 'DRAFT', 'TERMINATED')
4048: AND UPPER(MEANING) = UPPER(p_status_txt);
4049:

Line 4087: FROM FND_LOOKUPS

4083: AND ENABLED_FLAG = 'Y';
4084:
4085: CURSOR AUTHORING_PARTY_CSR (p_authoring_party_txt VARCHAR2) IS
4086: SELECT LOOKUP_CODE
4087: FROM FND_LOOKUPS
4088: WHERE LOOKUP_TYPE = 'OKC_AUTHORING_PARTY'
4089: AND UPPER(MEANING) = UPPER(p_authoring_party_txt);
4090:
4091: CURSOR CONTRACT_PARTIES_CSR (p_contract_id VARCHAR2) IS

Line 4129: FROM FND_LOOKUPS

4125: l_resolved_token VARCHAR2(100);
4126:
4127: CURSOR OVERALL_RISK_CSR(p_overall_risk_txt VARCHAR2) IS
4128: SELECT LOOKUP_CODE
4129: FROM FND_LOOKUPS
4130: WHERE LOOKUP_TYPE = 'OKC_RISK_LEVELS'
4131: AND UPPER(MEANING) = UPPER(p_overall_risk_txt);
4132:
4133: CURSOR notify_role_csr(p_notify_contact_role_txt VARCHAR2) IS

Line 8959: SELECT lookup_code FROM fnd_lookups

8955: WHERE Upper(name) = Upper(p_risk_event_txt)
8956: AND LANGUAGE = userenv('LANG');
8957:
8958: cursor c_risk_code_csr(p_risk_txt varchar2) IS
8959: SELECT lookup_code FROM fnd_lookups
8960: WHERE lookup_type = 'OKC_RISK_LEVELS'
8961: AND Upper(meaning) = Upper(p_risk_txt);
8962:
8963: CURSOR c_get_contract_details_csr(p_imp_contract_id NUMBER) IS