APPS.MSD_CS_COLLECTION dependencies on DUAL

Line 384: l_new_refresh_Num from dual;

380: l_process_type,
381: p_cs_name);
382: /* Get a new seq number for pull part */
383: SELECT msd.msd_last_refresh_number_s.nextval into
384: l_new_refresh_Num from dual;
385:
386: /* Refresh Target */
387: Refresh_Target(l_process_type, l_cs_rec.cs_definition_id,
388: l_cs_name, p_comp_refresh, p_instance_id,

Line 525: l_new_refresh_Num from dual;

521: p_cs_name );
522:
523: /* Get a new seq number for PULL part */
524: SELECT msd.msd_last_refresh_number_s.nextval into
525: l_new_refresh_Num from dual;
526:
527: /* Refresh Target */
528: Refresh_Target(l_process_type, l_cs_rec.cs_definition_id,
529: l_cs_name,p_comp_refresh, p_instance_id,

Line 1409: dual;

1405: decode(l_dcs_found, g_level_pk_not_found, 'DCS ', null)
1406: into
1407: l_comments2
1408: from
1409: dual;
1410:
1411: /* Level validation */
1412:
1413: if nvl(p_cs_rec.strict_flag, 'N') = 'Y' then

Line 1519: from dual;

1515: p_cs_rec.dcs_level_id, null,
1516: 'DCS ' )
1517: into
1518: l_comments1
1519: from dual;
1520: ELSE /* p_cs_rec.strict_flag = 'N' */
1521:
1522: /* Check whether that time level id exists in fnd lookup or not */
1523:

Line 1532: select 'TIM' into l_comments1 from dual;

1528: nvl(crec_data.tim_level_id, '999.99') = lookup_code and
1529: rownum <= 1;
1530:
1531: IF ( l_count < 1 ) THEN
1532: select 'TIM' into l_comments1 from dual;
1533: END IF;
1534: END IF;
1535:
1536: END IF;

Line 1545: from dual;

1541: /* MSD_CS_DATALOAD_INVALID_DIM - Invalid Dimensions */
1542: select decode(l_comments2, null, null, 'MSD_CS_DATALOAD_INVALID_DIM : ' || l_comments2) ||
1543: decode(l_comments1, null, null, 'MSD_CS_DATALOAD_INVALID_LVLID : ' || l_comments1)
1544: into p_err_mesg
1545: from dual;
1546:
1547: /* Validate Date Format */
1548: Begin
1549: select to_date(crec_data.attribute_43, 'YYYY/MM/DD')

Line 1551: from dual;

1547: /* Validate Date Format */
1548: Begin
1549: select to_date(crec_data.attribute_43, 'YYYY/MM/DD')
1550: into l_dummy_date
1551: from dual;
1552: Exception
1553: When others then
1554: p_err_mesg := p_err_mesg || ' MSD_CS_DATALOAD_INVALID_DATE_FORMAT : ATTRIBUTE_43';
1555: End;

Line 2041: FROM dual;

2037:
2038: /* Bug# 4349618 To commit in Batches */
2039: SELECT mod( l_counter, C_BATCH_SIZE)
2040: INTO l_commit_flag
2041: FROM dual;
2042:
2043: IF l_commit_flag = 0 THEN
2044: debug_line( 'Inside Process_1_Sub: commiting inside the loop.');
2045: commit;