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_MAINT_PROJECT_ACCUMS dependencies on PA_PROJECT_ACCUM_COMMITMENTS

Line 1896: UPDATE Pa_Project_Accum_Commitments PAA SET

1892: pa_proj_accum_main.x_last_update_login);
1893: end if;
1894: end if;
1895: if x_commitments_flag = 'Y' and pa_proj_accum_main.x_summ_process <> 'RL' then
1896: UPDATE Pa_Project_Accum_Commitments PAA SET
1897: Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + Tsk_cmt_raw_cost_itd,
1898: Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + Tsk_cmt_raw_cost_ytd,
1899: Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + Tsk_cmt_raw_cost_pp,
1900: Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + Tsk_cmt_raw_cost_ptd,

Line 1930: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

1926: where project_id = x_project_id
1927: and task_id = 0
1928: and resource_list_member_id = 0;
1929:
1930: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
1931: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
1932: CMT_RAW_COST_PTD,
1933: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
1934: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 2091: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

2087: pa_proj_accum_main.x_created_by,
2088: pa_proj_accum_main.x_last_update_login);
2089: end if;
2090: If x_create_commit = 'Y' then
2091: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2092: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2093: CMT_RAW_COST_PTD,
2094: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
2095: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 2243: UPDATE Pa_Project_Accum_Commitments PAA SET

2239: IF x_pac_flag = 'Y' and x_create_commit = 'Y' THEN
2240:
2241: BEGIN
2242:
2243: UPDATE Pa_Project_Accum_Commitments PAA SET
2244: Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + New_cmt_raw_cost_itd,
2245: Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + New_cmt_raw_cost_ytd,
2246: Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + New_cmt_raw_cost_pp,
2247: Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + New_cmt_raw_cost_ptd,

Line 2266: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

2262: last_update_login = pa_proj_accum_main.x_last_update_login
2263: Where PAA.Project_Accum_id = v_accum_id;
2264:
2265: if sql%notfound then
2266: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2267: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2268: CMT_RAW_COST_PTD,
2269: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
2270: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 2425: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

2421: pa_proj_accum_main.x_created_by,
2422: pa_proj_accum_main.x_last_update_login);
2423: end if;
2424: If x_create_wbs_commit = 'Y' then
2425: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2426: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2427: CMT_RAW_COST_PTD,
2428: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
2429: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 2577: UPDATE Pa_Project_Accum_Commitments PAA SET

2573: IF x_pac_flag = 'Y' and x_create_wbs_commit = 'Y' THEN
2574:
2575: BEGIN
2576:
2577: UPDATE Pa_Project_Accum_Commitments PAA SET
2578: Cmt_Raw_cost_itd = nvl(Cmt_Raw_cost_itd,0) + Prt_cmt_raw_cost_itd,
2579: Cmt_Raw_cost_ytd = nvl(Cmt_Raw_cost_ytd,0) + Prt_cmt_raw_cost_ytd,
2580: Cmt_Raw_cost_pp = nvl(Cmt_Raw_cost_pp,0) + Prt_cmt_raw_cost_pp,
2581: Cmt_Raw_cost_ptd = nvl(Cmt_Raw_cost_ptd,0) + Prt_cmt_raw_cost_ptd,

Line 2600: Insert into PA_PROJECT_ACCUM_COMMITMENTS (

2596: last_update_login = pa_proj_accum_main.x_last_update_login
2597: Where PAA.Project_Accum_id = v_accum_id;
2598:
2599: if sql%notfound then
2600: Insert into PA_PROJECT_ACCUM_COMMITMENTS (
2601: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,
2602: CMT_RAW_COST_PTD,
2603: CMT_BURDENED_COST_ITD,CMT_BURDENED_COST_YTD,
2604: CMT_BURDENED_COST_PP,CMT_BURDENED_COST_PTD,

Line 3454: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_COMMITMENTS

3450: x_err_code := SQLCODE;
3451: RAISE;
3452: End Initialize_budgets;
3453:
3454: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_COMMITMENTS
3455: -- Table. The Initialization will happen in case the current period is
3456: -- greater than the previously accumulated period. The procedure would
3457: -- be called only if the run-mode is 'I' (Incremental) .
3458:

Line 3516: Update PA_PROJECT_ACCUM_COMMITMENTS SET

3512:
3513: If x_current_start_date > x_prev_accum_start_date then
3514: If X_prev_period = x_prev_accum_period then
3515: If x_current_year > x_prev_accum_year then
3516: Update PA_PROJECT_ACCUM_COMMITMENTS SET
3517: CMT_RAW_COST_YTD = 0,
3518: CMT_RAW_COST_PP = CMT_RAW_COST_PTD,
3519: CMT_RAW_COST_PTD = 0,
3520: CMT_BURDENED_COST_YTD = 0,

Line 3533: Update PA_PROJECT_ACCUM_COMMITMENTS SET

3529: Where Project_Accum_id IN
3530: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3531: PAH.Project_Id = x_project_id);
3532: Else
3533: Update PA_PROJECT_ACCUM_COMMITMENTS SET
3534: CMT_RAW_COST_PP = CMT_RAW_COST_PTD,
3535: CMT_RAW_COST_PTD = 0,
3536: CMT_BURDENED_COST_PP = CMT_BURDENED_COST_PTD,
3537: CMT_BURDENED_COST_PTD = 0,

Line 3549: Update PA_PROJECT_ACCUM_COMMITMENTS SET

3545: PAH.Project_Id = x_project_id);
3546: End If;
3547: ElsIf X_prev_start_date > x_prev_accum_start_date then
3548: If x_current_year > x_prev_accum_year then
3549: Update PA_PROJECT_ACCUM_COMMITMENTS SET
3550: CMT_RAW_COST_YTD = 0,
3551: CMT_RAW_COST_PP = 0,
3552: CMT_RAW_COST_PTD = 0,
3553: CMT_BURDENED_COST_YTD = 0,

Line 3566: Update PA_PROJECT_ACCUM_COMMITMENTS SET

3562: Where Project_Accum_id IN
3563: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3564: PAH.Project_Id = x_project_id);
3565: Else
3566: Update PA_PROJECT_ACCUM_COMMITMENTS SET
3567: CMT_RAW_COST_PP = 0,
3568: CMT_RAW_COST_PTD = 0,
3569: CMT_BURDENED_COST_PP = 0,
3570: CMT_BURDENED_COST_PTD = 0,