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_PROCESS_ACCUM_COMMITMENTS dependencies on DUAL

Line 79: UNION select to_number(X_Proj_accum_id) from sys.dual );

75: pah.Resource_list_member_id = 0 and
76: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
77: start with pt.task_id = x_task_id
78: connect by prior pt.parent_task_id = pt.task_id)
79: UNION select to_number(X_Proj_accum_id) from sys.dual );
80: Recs_processed := Recs_processed + SQL%ROWCOUNT;
81:
82: -- Initially, the above statement might process just one row,the project level
83: -- row, since the Project-Task combinations might not have been created.

Line 113: From sys.Dual;

109:
110: IF v_noof_tasks > 0 Then
111: For i in 1..v_noof_tasks LOOP
112: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
113: From sys.Dual;
114: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
115: v_task_array(i),
116: x_current_period,
117: v_accum_id,

Line 228: UNION select to_number(X_Proj_accum_id) from sys.dual );

224: pah.Resource_list_member_id = 0 and
225: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
226: start with pt.task_id = x_task_id
227: connect by prior pt.parent_task_id = pt.task_id)
228: UNION select to_number(X_Proj_accum_id) from sys.dual );
229: Recs_processed := Recs_processed + SQL%ROWCOUNT;
230:
231: -- If the above procedure had returned any tasks , then we need to insert
232: -- header record and commitments record. We need to process the tasks one by one

Line 254: From sys.Dual;

250:
251: If v_noof_tasks > 0 Then
252: For i in 1..v_noof_tasks LOOP
253: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
254: From sys.Dual;
255: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
256: v_task_array(i),
257: x_current_period,
258: v_accum_id,

Line 368: UNION select to_number(X_Proj_accum_id) from sys.dual );

364: pah.Resource_list_member_id = 0 and
365: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
366: start with pt.task_id = x_task_id
367: connect by prior pt.parent_task_id = pt.task_id)
368: UNION select to_number(X_Proj_accum_id) from sys.dual );
369: Recs_processed := Recs_processed + SQL%ROWCOUNT;
370:
371: -- Initially, the above statement might process just one row,the project level
372: -- row, since the Project-Task combinations might not have been created.

Line 403: From sys.Dual;

399:
400: If v_noof_tasks > 0 Then
401: For i in 1..v_noof_tasks LOOP
402: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
403: From sys.Dual;
404: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
405: v_task_array(i),
406: x_current_period,
407: v_accum_id,

Line 514: UNION select to_number(X_Proj_accum_id) from sys.dual );

510: pah.Resource_list_member_id = 0 and
511: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
512: start with pt.task_id = x_task_id
513: connect by prior pt.parent_task_id = pt.task_id)
514: UNION select to_number(X_Proj_accum_id) from sys.dual );
515: Recs_processed := Recs_processed + SQL%ROWCOUNT;
516:
517: -- Initially, the above statement might process just one row,the project level
518: -- row, since the Project-Task combinations might not have been created.

Line 549: From sys.Dual;

545:
546: If v_noof_tasks > 0 Then
547: For i in 1..v_noof_tasks LOOP
548: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
549: From sys.Dual;
550: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
551: v_task_array(i),
552: x_current_period,
553: v_accum_id,

Line 658: UNION select to_number(X_Proj_accum_id) from sys.dual );

654: pah.Resource_list_member_id = 0 and
655: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
656: start with pt.task_id = x_task_id
657: connect by prior pt.parent_task_id = pt.task_id)
658: UNION select to_number(X_Proj_accum_id) from sys.dual );
659: Recs_processed := Recs_processed + SQL%ROWCOUNT;
660:
661: -- Initially, the above statement might process just one row,the project level
662: -- row, since the Project-Task combinations might not have been created.

Line 693: From sys.Dual;

689:
690: If v_noof_tasks > 0 Then
691: For i in 1..v_noof_tasks LOOP
692: Select PA_PROJECT_ACCUM_HEADERS_S.Nextval into V_Accum_id
693: From sys.Dual;
694: PA_MAINT_PROJECT_ACCUMS.Insert_Headers_tasks (X_project_id,
695: v_task_array(i),
696: x_current_period,
697: v_accum_id,