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.CS_CONTRACTS_PUB dependencies on CS_COVERAGE_TXN_GROUPS

Line 116: CURSOR chk_csr (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS

112: ) RETURN VARCHAR2 IS
113: l_index NUMBER;
114: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
115: l_return_error_exc EXCEPTION;
116: CURSOR chk_csr (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS
117: SELECT *
118: FROM cs_coverage_txn_groups
119: WHERE coverage_id = p_coverage_id;
120: l_cov_txn_grps_tbl coverage_txn_groups_tbl_type;

Line 118: FROM cs_coverage_txn_groups

114: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
115: l_return_error_exc EXCEPTION;
116: CURSOR chk_csr (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS
117: SELECT *
118: FROM cs_coverage_txn_groups
119: WHERE coverage_id = p_coverage_id;
120: l_cov_txn_grps_tbl coverage_txn_groups_tbl_type;
121: --------------------------------
122: -- FUNCTION val_start_end_dates

Line 189: (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS

185: p_coverage_rec IN coverages_rec_type
186: ) RETURN BOOLEAN IS
187: l_children_exist BOOLEAN := TRUE;
188: CURSOR chk_csr
189: (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS
190: SELECT *
191: FROM cs_coverage_txn_groups
192: WHERE coverage_id = p_coverage_id;
193: l_chk_rec chk_csr%ROWTYPE;

Line 191: FROM cs_coverage_txn_groups

187: l_children_exist BOOLEAN := TRUE;
188: CURSOR chk_csr
189: (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS
190: SELECT *
191: FROM cs_coverage_txn_groups
192: WHERE coverage_id = p_coverage_id;
193: l_chk_rec chk_csr%ROWTYPE;
194: BEGIN
195: OPEN chk_csr (p_coverage_rec.coverage_id);

Line 387: -- Normally, no check is required, however, CS_COVERAGE_TXN_GROUPS cannot

383: END IF;
384: ------------------------------------------------------------------------------
385: -- An optional relationship exists between CS_COVERAGES and
386: -- CS_COVERAGE_TXN_GRPS.
387: -- Normally, no check is required, however, CS_COVERAGE_TXN_GROUPS cannot
388: -- exist w/o records in CS_COV_TXN_GRP_CTRS. Therefore, if children
389: -- records exist in CS_COVERAGE_TXN_GROUPS for a given
390: -- CS_COVERAGES.COVERAGE_ID, then we must verify that records also exist
391: -- in CS_COV_TXN_GRP_CTRS.

Line 389: -- records exist in CS_COVERAGE_TXN_GROUPS for a given

385: -- An optional relationship exists between CS_COVERAGES and
386: -- CS_COVERAGE_TXN_GRPS.
387: -- Normally, no check is required, however, CS_COVERAGE_TXN_GROUPS cannot
388: -- exist w/o records in CS_COV_TXN_GRP_CTRS. Therefore, if children
389: -- records exist in CS_COVERAGE_TXN_GROUPS for a given
390: -- CS_COVERAGES.COVERAGE_ID, then we must verify that records also exist
391: -- in CS_COV_TXN_GRP_CTRS.
392: ------------------------------------------------------------------------------
393: IF (cov_txn_grp_children_exist(l_coverages_tbl(l_index))) THEN