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

Line 60: FROM okc_rep_contracts_all

56: l_doc_type varchar2(60);
57:
58: CURSOR c_get_doctype is
59: SELECT CONTRACT_TYPE
60: FROM okc_rep_contracts_all
61: WHERE CONTRACT_id = p_contract_id;
62:
63: BEGIN
64: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 244: FROM okc_rep_contracts_all

240: l_doc_type varchar2(60);
241:
242: CURSOR c_get_doctype is
243: SELECT CONTRACT_TYPE
244: FROM okc_rep_contracts_all
245: WHERE CONTRACT_id = p_contract_id;
246:
247:
248:

Line 411: FROM okc_rep_contracts_all

407: l_doc_type varchar2(60);
408:
409: CURSOR c_get_doctype is
410: SELECT CONTRACT_TYPE
411: FROM okc_rep_contracts_all
412: WHERE CONTRACT_id = p_contract_id;
413:
414:
415:

Line 1982: FROM OKC_REP_CONTRACTS_ALL

1978: WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ACQ_HIST', 'SBCR_PRE_ACQ')
1979: AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
1980: AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
1981: AND assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)
1982: FROM OKC_REP_CONTRACTS_ALL
1983: WHERE contract_id = p_contract_id)
1984: AND assoc.CLASSIFICATION_CODE = pg.CLASSIFICATION_CODE;
1985:
1986: IF (l_attr_count = 2) THEN

Line 2010: ' FROM okc_rep_contracts_all_ext_b' ||

2006: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2007: AND descriptive_flex_context_code = 'SBCR_PRE_ACQ';
2008:
2009: l_sql := 'SELECT ' || l_acq_type_col_name ||
2010: ' FROM okc_rep_contracts_all_ext_b' ||
2011: ' WHERE contract_id = ' || p_contract_id ||
2012: ' AND attr_group_id = ' || l_acq_hist_ag_id;
2013: BEGIN
2014: EXECUTE IMMEDIATE l_sql INTO l_acq_type;

Line 2024: FROM okc_rep_contracts_all_ext_b

2020:
2021: IF (l_acq_type = 'First Time Buy') THEN
2022:
2023: SELECT Count(*) INTO l_pre_acq_count
2024: FROM okc_rep_contracts_all_ext_b
2025: WHERE contract_id = p_contract_id
2026: AND attr_group_id = l_prev_acq_ag_id;
2027:
2028: IF (l_pre_acq_count > 0) THEN

Line 2059: FROM OKC_REP_CONTRACTS_ALL

2055: WHERE egv.ATTR_GROUP_NAME IN ( 'SBCR_ADD_INFO', 'SBCR_REC_AG')
2056: AND assoc.ATTR_GROUP_ID = egv.ATTR_GROUP_ID
2057: AND PG.ASSOCIATION_ID = assoc.ASSOCIATION_ID
2058: AND assoc.CLASSIFICATION_CODE = (SELECT To_Char(uda_template_id)
2059: FROM OKC_REP_CONTRACTS_ALL
2060: WHERE contract_id = p_contract_id)
2061: AND assoc.CLASSIFICATION_CODE = pg.CLASSIFICATION_CODE;
2062:
2063: IF (l_attr_count = 2) THEN

Line 2087: FROM okc_rep_contracts_all_ext_b

2083: WHERE descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
2084: AND descriptive_flex_context_code = 'SBCR_ADD_INFO';
2085:
2086: SELECT Count(*) INTO l_rec_count
2087: FROM okc_rep_contracts_all_ext_b
2088: WHERE contract_id = p_contract_id
2089: AND attr_group_id = l_rec_ag_id;
2090:
2091: IF(l_rec_count = 0) THEN

Line 2095: ' FROM okc_rep_contracts_all_ext_b' ||

2091: IF(l_rec_count = 0) THEN
2092:
2093:
2094: l_sql := 'SELECT ' || l_remarks_col_name ||
2095: ' FROM okc_rep_contracts_all_ext_b' ||
2096: ' WHERE contract_id = ' || p_contract_id ||
2097: ' AND attr_group_id = ' || l_add_info_ag_id;
2098: BEGIN
2099: EXECUTE IMMEDIATE l_sql INTO l_remarks;

Line 2421: FROM okc_rep_contracts_all

2417: l_api_name CONSTANT VARCHAR2(30) := 'validate_repository_for_qa';
2418: -- Contract cursor
2419: CURSOR contract_csr IS
2420: SELECT contract_effective_date,esignature_required
2421: FROM okc_rep_contracts_all
2422: WHERE contract_id = p_contract_id;
2423: contract_rec contract_csr%ROWTYPE;
2424:
2425: CURSOR contract_exp_csr IS

Line 2427: FROM okc_rep_contracts_all

2423: contract_rec contract_csr%ROWTYPE;
2424:
2425: CURSOR contract_exp_csr IS
2426: SELECT contract_expiration_date
2427: FROM okc_rep_contracts_all
2428: WHERE contract_id = p_contract_id;
2429: contract_exp_rec contract_exp_csr%ROWTYPE;
2430:
2431: -- Contract parties cursor, used for validating parties

Line 2960: FROM okc_rep_contracts_all

2956: l_warning_found Boolean := FALSE;
2957:
2958: CURSOR contract_csr IS
2959: SELECT contract_type, contract_expiration_date, contract_effective_date
2960: FROM okc_rep_contracts_all
2961: WHERE contract_id = p_contract_id;
2962:
2963: contract_rec contract_csr%ROWTYPE;
2964: