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 1410: dual;

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

Line 1520: from dual;

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

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

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

Line 1546: from dual;

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

Line 1552: from dual;

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

Line 2042: FROM dual;

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