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 DUAL

Line 2829: FROM DUAL;

2825: l_imp_error_id NUMBER;
2826:
2827: CURSOR ERROR_ID_CSR IS
2828: SELECT OKC_REP_IMP_ERRORS_T_S.NEXTVAL
2829: FROM DUAL;
2830:
2831: BEGIN
2832:
2833: l_api_name := 'populate_import_errors';

Line 3940: FROM DUAL;

3936: l_con_num_hook NUMBER;
3937:
3938: CURSOR CONTRACT_ID_CSR IS
3939: SELECT OKC_REP_CONTRACTS_ALL_S1.NEXTVAL
3940: FROM DUAL;
3941:
3942: CURSOR CONTRACT_NUMBER_CSR IS
3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3944: FROM DUAL;

Line 3944: FROM DUAL;

3940: FROM DUAL;
3941:
3942: CURSOR CONTRACT_NUMBER_CSR IS
3943: SELECT OKC_REP_CONTRACTS_ALL_S2.NEXTVAL
3944: FROM DUAL;
3945:
3946: CURSOR CONTRACT_NUMBER_CSR_3 IS
3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL
3948: FROM DUAL;

Line 3948: FROM DUAL;

3944: FROM DUAL;
3945:
3946: CURSOR CONTRACT_NUMBER_CSR_3 IS
3947: SELECT OKC_REP_CONTRACTS_ALL_S3.NEXTVAL
3948: FROM DUAL;
3949:
3950: CURSOR CONTRACT_NUMBER_CSR_4 IS
3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL
3952: FROM DUAL;

Line 3952: FROM DUAL;

3948: FROM DUAL;
3949:
3950: CURSOR CONTRACT_NUMBER_CSR_4 IS
3951: SELECT OKC_REP_CONTRACTS_ALL_S4.NEXTVAL
3952: FROM DUAL;
3953:
3954: CURSOR CONTRACT_NUMBER_CSR_5 IS
3955: SELECT OKC_REP_CONTRACTS_ALL_S5.NEXTVAL
3956: FROM DUAL;

Line 3956: FROM DUAL;

3952: FROM DUAL;
3953:
3954: CURSOR CONTRACT_NUMBER_CSR_5 IS
3955: SELECT OKC_REP_CONTRACTS_ALL_S5.NEXTVAL
3956: FROM DUAL;
3957:
3958: CURSOR CONTRACT_NUMBER_UNIQUE_CSR (p_contract_number VARCHAR2,p_contract_type VARCHAR2,p_org_id NUMBER ,p_contract_type_txt VARCHAR2,p_org_name VARCHAR2 , p_imp_contract_id NUMBER) IS
3959: SELECT CONTRACT_NUMBER
3960: FROM OKC_REP_CONTRACTS_ALL

Line 8331: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;

8327:
8328: END IF;
8329:
8330:
8331: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;
8332:
8333:
8334:
8335: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8383: SELECT Nvl((SELECT 'Y' FROM okc_rep_contracts_all WHERE contract_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_subentities_yn FROM dual;

8379:
8380: END IF;
8381:
8382:
8383: SELECT Nvl((SELECT 'Y' FROM okc_rep_contracts_all WHERE contract_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_subentities_yn FROM dual;
8384:
8385: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8386: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
8387: 'OKC_REP_UTIL_PVT.DocTyp_subent_disabled_yn returns x_disable_subentities_yn as : '