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_COVERAGES

Line 132: -- START and END dates of CS_COVERAGES

128: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
129: l_return_error_exc EXCEPTION;
130: BEGIN
131: -- Validate START and END dates of Coverage_Txn_Groups fall within the
132: -- START and END dates of CS_COVERAGES
133: IF (p_cov_txn_grps_rec.coverage_start_date < p_coverages_rec.start_date_active) THEN
134: FND_MESSAGE.set_name(G_APP_NAME, G_INVALID_TXN_GRP_DATE);
135: FND_MESSAGE.set_token(G_TXN_GRP_DATE_TOKEN,
136: TO_CHAR(p_cov_txn_grps_rec.coverage_start_date, G_DATE_FORMAT));

Line 166: -- START and END dates of CS_COVERAGES

162: l_index := l_cov_txn_grps_tbl.FIRST;
163: LOOP
164: -----------------------------------------------------------------------
165: -- Validate START and END dates of Coverage_Txn_Groups fall within the
166: -- START and END dates of CS_COVERAGES
167: -----------------------------------------------------------------------
168: l_return_status := val_start_end_dates(l_cov_txn_grps_tbl(l_index), p_coverages_rec);
169: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
170: RAISE l_return_error_exc;

Line 290: CURSOR chk_csr (p_coverage_id IN CS_COVERAGES.COVERAGE_ID%TYPE) IS

286: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
287: l_index NUMBER := 0;
288: l_return_error_exc EXCEPTION;
289:
290: CURSOR chk_csr (p_coverage_id IN CS_COVERAGES.COVERAGE_ID%TYPE) IS
291: SELECT *
292: FROM cs_coverages
293: WHERE coverage_id = p_coverage_id;
294:

Line 292: FROM cs_coverages

288: l_return_error_exc EXCEPTION;
289:
290: CURSOR chk_csr (p_coverage_id IN CS_COVERAGES.COVERAGE_ID%TYPE) IS
291: SELECT *
292: FROM cs_coverages
293: WHERE coverage_id = p_coverage_id;
294:
295: l_coverages_tbl coverages_tbl_type;
296: -----------------------------------------

Line 304: set_msg_no_children('CS_CP_SERVICES_ALL', 'CS_COVERAGES');

300: p_coverages_tbl IN coverages_tbl_type
301: ) IS
302: BEGIN
303: IF (p_coverages_tbl.COUNT = 0) THEN
304: set_msg_no_children('CS_CP_SERVICES_ALL', 'CS_COVERAGES');
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: RAISE l_return_error_exc;
307: END IF;
308: END verify_cov_children_exist;

Line 385: -- An optional relationship exists between CS_COVERAGES and

381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
382: RAISE l_return_error_exc;
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

Line 390: -- CS_COVERAGES.COVERAGE_ID, then we must verify that records also exist

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
394: l_return_status := val_cov_txn_grps_children (l_coverages_tbl(l_index));