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_ACCUM_UTILS dependencies on PA_PROJECT_ACCUM_HEADERS

Line 7: -- creates a record in PA_PROJECT_ACCUM_HEADERS and

3:
4: -- Proj_level_record - This verifies for the existence of the Project level
5: -- record (Task id = 0 and Resource list member id = 0)
6: -- If available, returns the Project_Accum_id else
7: -- creates a record in PA_PROJECT_ACCUM_HEADERS and
8: -- returns the Project_Accum_Id
9:
10:
11:

Line 55: PA_PROJECT_ACCUM_HEADERS

51: INTO
52: V_Accum_id,
53: V_prev_accum_period
54: FROM
55: PA_PROJECT_ACCUM_HEADERS
56: WHERE Project_id = X_project_id
57: AND Task_id = 0
58: AND Resource_List_id = 0
59: AND Resource_List_member_id = 0

Line 78: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval

74: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
75: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header Record');
76: END IF;
77:
78: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
79: INTO V_accum_id
80: FROM Dual;
81: INSERT INTO PA_PROJECT_ACCUM_HEADERS
82: (PROJECT_ACCUM_ID,

Line 81: INSERT INTO PA_PROJECT_ACCUM_HEADERS

77:
78: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
79: INTO V_accum_id
80: FROM Dual;
81: INSERT INTO PA_PROJECT_ACCUM_HEADERS
82: (PROJECT_ACCUM_ID,
83: PROJECT_ID,
84: TASK_ID,
85: ACCUM_PERIOD,

Line 511: -- combination in the PA_PROJECT_ACCUM_HEADERS table,

507: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
508:
509:
510: -- Check_Actuals_Details - For the given Project,Task and Resource
511: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
512: -- checks for detail records in
513: -- PA_PROJECT_ACCUM_ACTUALS table. It is possible
514: -- that the Headers table might have a record
515: -- but no corresponding detail record. This procedure

Line 528: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no

524: V_err_code Number := 0;
525: V_Old_Stack Varchar2(630);
526:
527: -- This cursor gets the Accum_id for the given Project,Task and Resource
528: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no
529: -- corresponding record in PA_PROJECT_ACCUM_ACTUALS.
530:
531: CURSOR Get_Accum_Id_Cur is
532: Select Project_accum_id

Line 534: PA_PROJECT_ACCUM_HEADERS PAH

530:
531: CURSOR Get_Accum_Id_Cur is
532: Select Project_accum_id
533: FROM
534: PA_PROJECT_ACCUM_HEADERS PAH
535: WHERE Project_id = x_project_id
536: and TASK_ID = V_task_id
537: and RESOURCE_LIST_MEMBER_ID = x_resource_list_member_id
538: and not exists

Line 625: PA_PROJECT_ACCUM_HEADERS PAH

621: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,
622: 0,Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
623: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
624: from
625: PA_PROJECT_ACCUM_HEADERS PAH
626: Where Project_Id = x_project_id
627: and Task_id = v_task_array(i)
628: and Resource_list_member_id = x_Resource_list_member_id
629: and Not Exists

Line 660: -- combination in the PA_PROJECT_ACCUM_HEADERS table,

656: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
657:
658:
659: -- Check_Cmt_Details - For the given Project,Task and Resource
660: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
661: -- checks for detail records in
662: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible
663: -- that the Headers table might have a record
664: -- but no corresponding detail record. This procedure

Line 677: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no

673: V_err_code Number := 0;
674: V_Old_Stack Varchar2(630);
675:
676: -- This cursor gets the Accum_id for the given Project,Task and Resource
677: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no
678: -- corresponding record in PA_PROJECT_ACCUM_COMMITMENTS
679:
680: CURSOR Get_Accum_Id_Cur is
681: Select Project_accum_id

Line 683: PA_PROJECT_ACCUM_HEADERS PAH

679:
680: CURSOR Get_Accum_Id_Cur is
681: Select Project_accum_id
682: from
683: PA_PROJECT_ACCUM_HEADERS PAH
684: Where Project_id = x_project_id
685: and TASK_ID = V_task_id
686: and RESOURCE_LIST_MEMBER_ID = x_resource_list_member_id
687: and not exists

Line 760: from PA_PROJECT_ACCUM_HEADERS PAH

756: LAST_UPDATE_LOGIN)
757: Select PROJECT_ACCUM_ID,0,0,0,0,0,0,0,0,0,0,0,0,
758: Null,pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(sysdate),
759: Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
760: from PA_PROJECT_ACCUM_HEADERS PAH
761: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
762: Resource_list_member_id = x_Resource_list_member_id and
763: Not Exists (Select 'x' from PA_PROJECT_ACCUM_COMMITMENTS PAC Where
764: PAH.PROJECT_ACCUM_ID = PAC.PROJECT_ACCUM_ID);

Line 790: -- combination in the PA_PROJECT_ACCUM_HEADERS table,

786: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
787: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
788:
789: -- Check_Budget_Details - For the given Project,Task and Resource
790: -- combination in the PA_PROJECT_ACCUM_HEADERS table,
791: -- checks for detail records in
792: -- PA_PROJECT_ACCUM_COMMITMENTS table. It is possible
793: -- that the Headers table might have a record
794: -- but no corresponding detail record. This procedure

Line 807: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no

803: V_err_code Number := 0;
804: V_Old_Stack Varchar2(630);
805:
806: -- This cursor gets the Accum_id for the given Project,Task and Resource
807: -- combination which has a record in PA_PROJECT_ACCUM_HEADERS but no
808: -- corresponding record in PA_PROJECT_ACCUM_BUDGETS
809:
810: CURSOR Get_Accum_Id_Cur IS
811: SELECT

Line 814: PA_PROJECT_ACCUM_HEADERS PAH

810: CURSOR Get_Accum_Id_Cur IS
811: SELECT
812: Project_accum_id
813: FROM
814: PA_PROJECT_ACCUM_HEADERS PAH
815: WHERE Project_id = x_project_id
816: and TASK_ID = v_task_id
817: and RESOURCE_LIST_MEMBER_ID = x_resource_list_member_id
818: and not exists

Line 922: from PA_PROJECT_ACCUM_HEADERS PAH

918: Select PROJECT_ACCUM_ID,x_budget_type_code,0,0,0,0,0,0,0,0,0,0,
919: 0,0,0,0,0,0,0,0,0,0,
920: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,0,0,0,0,0,0,0,0,0,
921: pa_proj_accum_main.x_request_id,pa_proj_accum_main.x_last_updated_by,Trunc(Sysdate),Trunc(Sysdate),pa_proj_accum_main.x_created_by,pa_proj_accum_main.x_last_update_login
922: from PA_PROJECT_ACCUM_HEADERS PAH
923: Where Project_Id = x_project_id and Task_id = v_task_array(i) and
924: Resource_list_member_id = x_Resource_list_member_id and
925: Not Exists (Select 'x' from PA_PROJECT_ACCUM_BUDGETS PAB Where
926: PAH.PROJECT_ACCUM_ID = PAB.PROJECT_ACCUM_ID

Line 1043: -- PA_PROJECT_ACCUM_HEADERS .

1039: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
1040:
1041: -- Get_existing_higher_tasks - For the given task, returns all the higher level
1042: -- tasks which are available in
1043: -- PA_PROJECT_ACCUM_HEADERS .
1044:
1045: Cursor Tasks_Cur is
1046: Select task_id
1047: from

Line 1054: pa_project_accum_headers pah

1050: and task_id <> x_task_id
1051: and exists
1052: (select 'x'
1053: from
1054: pa_project_accum_headers pah
1055: where pah.project_id = x_project_id
1056: and pah.task_id = pt.task_id
1057: and pah.resource_list_member_id = x_resource_list_member_id)
1058: start with task_id = x_task_id

Line 1108: UPDATE pa_project_accum_headers

1104: END IF;
1105:
1106: -- update the accum_period to current period
1107:
1108: UPDATE pa_project_accum_headers
1109: SET
1110: accum_period = x_accum_period,
1111: request_id = pa_proj_accum_main.x_request_id,
1112: last_updated_by = pa_proj_accum_main.x_last_updated_by,

Line 1149: UPDATE pa_project_accum_headers

1145: END IF;
1146:
1147: -- update the accum_period to current period
1148:
1149: UPDATE pa_project_accum_headers
1150: SET
1151: tasks_restructured_flag = x_tasks_restructured_flag,
1152: request_id = pa_proj_accum_main.x_request_id,
1153: last_updated_by = pa_proj_accum_main.x_last_updated_by,

Line 1194: pa_project_accum_headers

1190: NVL(tasks_restructured_flag,'N')
1191: INTO
1192: x_tasks_restructured_flag
1193: FROM
1194: pa_project_accum_headers
1195: WHERE project_accum_id = x_project_accum_id;
1196:
1197: -- Restore the old x_err_stack;
1198: