APPS.MSC_WS_APS_DATA_SERVICES dependencies on DUAL

Line 141: SELECT MSD_DP_SCENARIOS_S.NEXTVAL INTO ScenarioId FROM DUAL;

137: ScenarioName IN VARCHAR2
138: ) AS
139: BEGIN
140: BEGIN
141: SELECT MSD_DP_SCENARIOS_S.NEXTVAL INTO ScenarioId FROM DUAL;
142:
143: INSERT INTO msd_dp_scenarios
144: (
145: demand_plan_id, scenario_id, scenario_name, forecast_based_on,

Line 487: -- SELECT StartDate + 6 INTO l_Date FROM DUAL;

483: RETURN 'INVALID_START_END_DATE_FOR_DAILY_BUCKET';
484: END IF;
485: ELSIF BucketType = 2 THEN -- weekly bucket
486: -- l_Date := StartDate + 6;
487: -- SELECT StartDate + 6 INTO l_Date FROM DUAL;
488: IF StartDate + 6 <> EndDate THEN
489: -- IF l_Date <> EndDate THEN
490: RETURN 'INVALID_START_END_DATE_FOR_WEEKLY_BUCKET';
491: END IF;

Line 494: -- SELECT StartDate + 27 INTO l_Date FROM DUAL; -- 4 weeks

490: RETURN 'INVALID_START_END_DATE_FOR_WEEKLY_BUCKET';
491: END IF;
492: ELSE -- monthly bucket can be 5/5 weeks or Gregorian calendar month
493: -- start with 4 weeks
494: -- SELECT StartDate + 27 INTO l_Date FROM DUAL; -- 4 weeks
495: -- IF l_Date <> EndDate THEN
496: IF StartDate + 27 <> EndDate THEN
497: -- its not 4 weeks period, try 5 weeks
498: -- SELECT StartDate + 34 INTO l_Date FROM DUAL; -- 5 weeks

Line 498: -- SELECT StartDate + 34 INTO l_Date FROM DUAL; -- 5 weeks

494: -- SELECT StartDate + 27 INTO l_Date FROM DUAL; -- 4 weeks
495: -- IF l_Date <> EndDate THEN
496: IF StartDate + 27 <> EndDate THEN
497: -- its not 4 weeks period, try 5 weeks
498: -- SELECT StartDate + 34 INTO l_Date FROM DUAL; -- 5 weeks
499: -- IF l_Date <> EndDate THEN
500: IF StartDate + 34 <> EndDate THEN
501: -- its not 5 weeks, try Gregorian calendar month
502: SELECT TRUNC(StartDate, 'MONTH') INTO l_Date FROM DUAL;

Line 502: SELECT TRUNC(StartDate, 'MONTH') INTO l_Date FROM DUAL;

498: -- SELECT StartDate + 34 INTO l_Date FROM DUAL; -- 5 weeks
499: -- IF l_Date <> EndDate THEN
500: IF StartDate + 34 <> EndDate THEN
501: -- its not 5 weeks, try Gregorian calendar month
502: SELECT TRUNC(StartDate, 'MONTH') INTO l_Date FROM DUAL;
503: -- check if StartDate is the first day of the month
504: IF StartDate <> l_Date THEN
505: RETURN 'INVALID_START_END_DATE_FOR_MONTHLY_BUCKET';
506: ELSE

Line 507: SELECT LAST_DAY(StartDate) INTO l_Date FROM DUAL;

503: -- check if StartDate is the first day of the month
504: IF StartDate <> l_Date THEN
505: RETURN 'INVALID_START_END_DATE_FOR_MONTHLY_BUCKET';
506: ELSE
507: SELECT LAST_DAY(StartDate) INTO l_Date FROM DUAL;
508: -- check if EndDate is the last day of the month
509: IF EndDate <> l_Date THEN
510: RETURN 'INVALID_START_END_DATE_FOR_MONTHLY_BUCKET';
511: END IF;

Line 2176: SELECT msc_supplies_s.nextval INTO l_TransactionId FROM DUAL;

2172: ) AS
2173: l_TransactionId NUMBER;
2174: BEGIN
2175: -- generate an unique demand id
2176: SELECT msc_supplies_s.nextval INTO l_TransactionId FROM DUAL;
2177:
2178: -- insert data
2179: INSERT INTO msc_supplies
2180: (