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 1374: /Commenting below for Bug 7012687 : not use Select from dual to evaluate expression/

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

Line 1379: --from dual;

1375: /* Added for Bug 5549814*/
1376: /* Utilizing the fact that 01-01-1950 was a Sunday and PA lookups value for a Sunday is 1 */
1377: --Select (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')))
1378: --into l_week_starting_day
1379: --from dual;
1380:
1381: /*Adding below for Bug 7012687*/
1382: l_week_starting_day := (trim(to_char((to_date('01-01-1950','dd-mm-yyyy')+(l_week_starting_day_index - 1)),'DAY')));
1383:

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

1385: /* Bug#2462076 Added code for using trunc on the start and end date parameters */
1386: l_week_starting_date := trunc(p_start_date);
1387: l_end_date := trunc(p_end_date);
1388: LOOP
1389: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1390: --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*/
1391: --INTO l_week_ending_date
1392: --FROM dual;
1393:

Line 1392: --FROM dual;

1388: LOOP
1389: /*Commenting below for Bug 7012687 : not use Select from dual to evaluate expression*/
1390: --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*/
1391: --INTO l_week_ending_date
1392: --FROM dual;
1393:
1394: /*Adding below for Bug 7012687*/
1395: l_week_ending_date := (NEXT_DAY(l_week_starting_date,l_week_starting_day)-1);
1396: