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.PA_FORECAST_ITEMS_UTILS dependencies on DUAL

Line 20: FROM DUAL;

16: BEGIN
17:
18: SELECT pa_forecast_items_s.NEXTVAL
19: INTO li_forecast_item_id
20: FROM DUAL;
21:
22: EXCEPTION
23: WHEN OTHERS then
24: RAISE;

Line 1367: /Commenting below for Bug 7012687 : not use Select from dual to evaluate expression/

1363: -- Taking value of the day from the profile option
1364:
1365: l_week_starting_day_index := TO_NUMBER(FND_PROFILE.VALUE('PA_GLOBAL_WEEK_START_DAY'));
1366:
1367: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1368: /* Added for Bug 5549814*/
1369: /* Utilizing the fact that 01-01-1950 was a Sunday and PA lookups value for a Sunday is 1 */
1370: --Select (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')))
1371: --into l_week_starting_day

Line 1372: --from dual;

1368: /* Added for Bug 5549814*/
1369: /* Utilizing the fact that 01-01-1950 was a Sunday and PA lookups value for a Sunday is 1 */
1370: --Select (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')))
1371: --into l_week_starting_day
1372: --from dual;
1373:
1374: /*Adding below for Bug 7012687*/
1375: l_week_starting_day := (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')));
1376:

Line 1382: /Commenting below for Bug 7012687 : not use Select from dual to evaluate expression/

1378: /* Bug#2462076 Added code for using trunc on the start and end date parameters */
1379: l_week_starting_date := trunc(p_start_date);
1380: l_end_date := trunc(p_end_date);
1381: LOOP
1382: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1383: --SELECT (NEXT_DAY(l_week_starting_date,l_week_starting_day)-1) /*Bug 5549814 - Changed l_week_starting_day_index to l_week_starting_day*/
1384: --INTO l_week_ending_date
1385: --FROM dual;
1386:

Line 1385: --FROM dual;

1381: LOOP
1382: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1383: --SELECT (NEXT_DAY(l_week_starting_date,l_week_starting_day)-1) /*Bug 5549814 - Changed l_week_starting_day_index to l_week_starting_day*/
1384: --INTO l_week_ending_date
1385: --FROM dual;
1386:
1387: /*Adding below for Bug 7012687*/
1388: l_week_ending_date := (NEXT_DAY(l_week_starting_date,l_week_starting_day)-1);
1389: