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_DELETE_ACCUM_RECS dependencies on PA_PROJ_ACCUM_MAIN

Line 75: AND rownum <= pa_proj_accum_main.x_commit_size;

71: from PA_PROJECT_ACCUM_HEADERS PAH
72: Where PAH.Project_Id = x_project_id
73: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level record
74: )
75: AND rownum <= pa_proj_accum_main.x_commit_size;
76: if sql%rowcount < pa_proj_accum_main.x_commit_size then
77: /* Commented for Bug 2984871 Commit;*/
78: tot_recs_processed := tot_recs_processed + sql%rowcount;
79: Commit;

Line 76: if sql%rowcount < pa_proj_accum_main.x_commit_size then

72: Where PAH.Project_Id = x_project_id
73: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level record
74: )
75: AND rownum <= pa_proj_accum_main.x_commit_size;
76: if sql%rowcount < pa_proj_accum_main.x_commit_size then
77: /* Commented for Bug 2984871 Commit;*/
78: tot_recs_processed := tot_recs_processed + sql%rowcount;
79: Commit;
80: exit;

Line 105: ,REQUEST_ID = pa_proj_accum_main.x_request_id

101: ,CMT_QUANTITY_YTD = 0
102: ,CMT_QUANTITY_PP = 0
103: ,CMT_QUANTITY_PTD = 0
104: ,CMT_UNIT_OF_MEASURE = NULL
105: ,REQUEST_ID = pa_proj_accum_main.x_request_id
106: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
107: ,LAST_UPDATE_DATE = Trunc(sysdate)
108: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
109: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;

Line 106: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by

102: ,CMT_QUANTITY_PP = 0
103: ,CMT_QUANTITY_PTD = 0
104: ,CMT_UNIT_OF_MEASURE = NULL
105: ,REQUEST_ID = pa_proj_accum_main.x_request_id
106: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
107: ,LAST_UPDATE_DATE = Trunc(sysdate)
108: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
109: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;
110:

Line 108: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

104: ,CMT_UNIT_OF_MEASURE = NULL
105: ,REQUEST_ID = pa_proj_accum_main.x_request_id
106: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
107: ,LAST_UPDATE_DATE = Trunc(sysdate)
108: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
109: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;
110:
111:
112: COMMIT;

Line 368: ,REQUEST_ID = pa_proj_accum_main.x_request_id

364: ,BASE_LABOR_HOURS_TOT = 0
365: ,ORIG_LABOR_HOURS_TOT = 0
366: ,BASE_QUANTITY_TOT = 0
367: ,ORIG_QUANTITY_TOT = 0
368: ,REQUEST_ID = pa_proj_accum_main.x_request_id
369: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
370: ,LAST_UPDATE_DATE = Trunc(sysdate)
371: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
372: WHERE Budget_Type_Code = Budget_ver_rec.budget_type_code

Line 369: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by

365: ,ORIG_LABOR_HOURS_TOT = 0
366: ,BASE_QUANTITY_TOT = 0
367: ,ORIG_QUANTITY_TOT = 0
368: ,REQUEST_ID = pa_proj_accum_main.x_request_id
369: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
370: ,LAST_UPDATE_DATE = Trunc(sysdate)
371: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
372: WHERE Budget_Type_Code = Budget_ver_rec.budget_type_code
373: AND Project_Accum_id = l_Prj_Lvl_Accum_Id;

Line 371: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

367: ,ORIG_QUANTITY_TOT = 0
368: ,REQUEST_ID = pa_proj_accum_main.x_request_id
369: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
370: ,LAST_UPDATE_DATE = Trunc(sysdate)
371: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
372: WHERE Budget_Type_Code = Budget_ver_rec.budget_type_code
373: AND Project_Accum_id = l_Prj_Lvl_Accum_Id;
374:
375:

Line 480: AND rownum <= pa_proj_accum_main.x_commit_size;

476: from PA_PROJECT_ACCUM_HEADERS PAH
477: Where PAH.Project_Id = x_project_id
478: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level records
479: )
480: AND rownum <= pa_proj_accum_main.x_commit_size;
481: if sql%rowcount < pa_proj_accum_main.x_commit_size then
482: /* Commented for Bug 2984871 Commit;*/
483: tot_recs_processed := tot_recs_processed + sql%rowcount;
484: Commit;

Line 481: if sql%rowcount < pa_proj_accum_main.x_commit_size then

477: Where PAH.Project_Id = x_project_id
478: and PAH.project_accum_id <> l_Prj_Lvl_Accum_Id -- Skip project-level records
479: )
480: AND rownum <= pa_proj_accum_main.x_commit_size;
481: if sql%rowcount < pa_proj_accum_main.x_commit_size then
482: /* Commented for Bug 2984871 Commit;*/
483: tot_recs_processed := tot_recs_processed + sql%rowcount;
484: Commit;
485: exit;

Line 535: ,REQUEST_ID = pa_proj_accum_main.x_request_id

531: ,REVENUE_YTD = 0
532: ,REVENUE_PP = 0
533: ,REVENUE_PTD = 0
534: ,TXN_UNIT_OF_MEASURE = NULL
535: ,REQUEST_ID = pa_proj_accum_main.x_request_id
536: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
537: ,LAST_UPDATE_DATE = Trunc(sysdate)
538: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
539: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;

Line 536: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by

532: ,REVENUE_PP = 0
533: ,REVENUE_PTD = 0
534: ,TXN_UNIT_OF_MEASURE = NULL
535: ,REQUEST_ID = pa_proj_accum_main.x_request_id
536: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
537: ,LAST_UPDATE_DATE = Trunc(sysdate)
538: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
539: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;
540:

Line 538: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

534: ,TXN_UNIT_OF_MEASURE = NULL
535: ,REQUEST_ID = pa_proj_accum_main.x_request_id
536: ,LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by
537: ,LAST_UPDATE_DATE = Trunc(sysdate)
538: ,LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
539: WHERE Project_Accum_id = l_Prj_Lvl_Accum_Id;
540:
541:
542: COMMIT;

Line 588: and rownum <= pa_proj_accum_main.x_commit_size;

584: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
585: PAH.Project_Id = x_project_id and
586: PAH.resource_list_member_id <> 0 and
587: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
588: and rownum <= pa_proj_accum_main.x_commit_size;
589:
590: if sql%rowcount < pa_proj_accum_main.x_commit_size then
591: /* Commented for Bug 2984871 Commit;*/
592: tot_recs_processed := tot_recs_processed + sql%rowcount;

Line 590: if sql%rowcount < pa_proj_accum_main.x_commit_size then

586: PAH.resource_list_member_id <> 0 and
587: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
588: and rownum <= pa_proj_accum_main.x_commit_size;
589:
590: if sql%rowcount < pa_proj_accum_main.x_commit_size then
591: /* Commented for Bug 2984871 Commit;*/
592: tot_recs_processed := tot_recs_processed + sql%rowcount;
593: Commit;
594: exit;

Line 648: and rownum <= pa_proj_accum_main.x_commit_size;

644: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
645: PAH.Project_Id = x_project_id and
646: PAH.resource_list_member_id <> 0 and
647: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
648: and rownum <= pa_proj_accum_main.x_commit_size;
649:
650: if sql%rowcount < pa_proj_accum_main.x_commit_size then
651: /* Commented for Bug 2984871 Commit;*/
652: tot_recs_processed := tot_recs_processed + sql%rowcount;

Line 650: if sql%rowcount < pa_proj_accum_main.x_commit_size then

646: PAH.resource_list_member_id <> 0 and
647: PAH.Resource_List_id = NVL(x_Resource_list_id,PAH.Resource_List_id))
648: and rownum <= pa_proj_accum_main.x_commit_size;
649:
650: if sql%rowcount < pa_proj_accum_main.x_commit_size then
651: /* Commented for Bug 2984871 Commit;*/
652: tot_recs_processed := tot_recs_processed + sql%rowcount;
653: Commit;
654: exit;

Line 748: and rownum <= pa_proj_accum_main.x_commit_size;

744: Where PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID)
745: AND Not Exists
746: (Select 'Yes' from PA_PROJECT_ACCUM_BUDGETS PAB
747: Where PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID)
748: and rownum <= pa_proj_accum_main.x_commit_size;
749:
750:
751: if sql%rowcount < pa_proj_accum_main.x_commit_size then
752: /* Commented for Bug 2984871 Commit;*/

Line 751: if sql%rowcount < pa_proj_accum_main.x_commit_size then

747: Where PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID)
748: and rownum <= pa_proj_accum_main.x_commit_size;
749:
750:
751: if sql%rowcount < pa_proj_accum_main.x_commit_size then
752: /* Commented for Bug 2984871 Commit;*/
753: tot_recs_processed := tot_recs_processed + sql%rowcount;
754: Commit;
755: exit;