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_ACTUALS

Line 1769: -- Update pa_project_accum_actuals project level records

1765: END LOOP; -- End of x_Txn_Accum_rec in PA_Txn_Accum_cur LOOP
1766:
1767: CLOSE PA_Txn_Accum_Cur;
1768: CLOSE res_accum_cur;
1769: -- Update pa_project_accum_actuals project level records
1770: if (x_actual_cost_flag = 'Y' or x_revenue_flag = 'Y')
1771: and pa_proj_accum_main.x_summ_process <> 'RL' then
1772: UPDATE Pa_Project_Accum_actuals PAA SET
1773: Raw_cost_itd = nvl(raw_cost_itd,0) + Tsk_raw_cost_itd,

Line 1772: UPDATE Pa_Project_Accum_actuals PAA SET

1768: CLOSE res_accum_cur;
1769: -- Update pa_project_accum_actuals project level records
1770: if (x_actual_cost_flag = 'Y' or x_revenue_flag = 'Y')
1771: and pa_proj_accum_main.x_summ_process <> 'RL' then
1772: UPDATE Pa_Project_Accum_actuals PAA SET
1773: Raw_cost_itd = nvl(raw_cost_itd,0) + Tsk_raw_cost_itd,
1774: Raw_cost_ytd = nvl(raw_cost_ytd,0) + Tsk_raw_cost_ytd,
1775: Raw_cost_pp = nvl(raw_cost_pp,0) + Tsk_raw_cost_pp,
1776: Raw_cost_ptd = nvl(raw_cost_ptd,0) + Tsk_raw_cost_ptd,

Line 1834: Insert into PA_PROJECT_ACCUM_ACTUALS (

1830: where project_id = x_project_id
1831: and task_id = 0
1832: and resource_list_member_id = 0;
1833:
1834: Insert into PA_PROJECT_ACCUM_ACTUALS (
1835: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
1836: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
1837: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
1838: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2030: Insert into PA_PROJECT_ACCUM_ACTUALS (

2026: pa_proj_accum_main.x_created_by,
2027: pa_proj_accum_main.x_last_update_login );
2028:
2029: If x_create_actuals = 'Y' then
2030: Insert into PA_PROJECT_ACCUM_ACTUALS (
2031: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2032: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2033: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2034: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2127: UPDATE Pa_Project_Accum_actuals PAA SET

2123: IF x_paa_flag = 'Y' and x_create_actuals = 'Y' THEN
2124:
2125: BEGIN
2126:
2127: UPDATE Pa_Project_Accum_actuals PAA SET
2128: Raw_cost_itd = nvl(Raw_cost_itd,0) + New_raw_cost_itd,
2129: Raw_cost_ytd = nvl(Raw_cost_ytd,0) + New_raw_cost_ytd,
2130: Raw_cost_pp = nvl(Raw_cost_pp,0) + New_raw_cost_pp,
2131: Raw_cost_ptd = nvl(Raw_cost_ptd,0) + New_raw_cost_ptd,

Line 2174: Insert into PA_PROJECT_ACCUM_ACTUALS (

2170: last_update_login = pa_proj_accum_main.x_last_update_login
2171: Where PAA.Project_Accum_id = v_accum_id;
2172:
2173: if sql%notfound then
2174: Insert into PA_PROJECT_ACCUM_ACTUALS (
2175: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2176: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2177: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2178: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2364: Insert into PA_PROJECT_ACCUM_ACTUALS (

2360: pa_proj_accum_main.x_created_by,
2361: pa_proj_accum_main.x_last_update_login );
2362:
2363: If x_create_wbs_actuals = 'Y' then
2364: Insert into PA_PROJECT_ACCUM_ACTUALS (
2365: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2366: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2367: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2368: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2461: UPDATE Pa_Project_Accum_actuals PAA SET

2457: IF x_paa_flag = 'Y' and x_create_wbs_actuals = 'Y' THEN
2458:
2459: BEGIN
2460:
2461: UPDATE Pa_Project_Accum_actuals PAA SET
2462: Raw_cost_itd = nvl(Raw_cost_itd,0) + Prt_raw_cost_itd,
2463: Raw_cost_ytd = nvl(Raw_cost_ytd,0) + Prt_raw_cost_ytd,
2464: Raw_cost_pp = nvl(Raw_cost_pp,0) + Prt_raw_cost_pp,
2465: Raw_cost_ptd = nvl(Raw_cost_ptd,0) + Prt_raw_cost_ptd,

Line 2508: Insert into PA_PROJECT_ACCUM_ACTUALS (

2504: last_update_login = pa_proj_accum_main.x_last_update_login
2505: Where PAA.Project_Accum_id = v_accum_id;
2506:
2507: if sql%notfound then
2508: Insert into PA_PROJECT_ACCUM_ACTUALS (
2509: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2510: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2511: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2512: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2733: -- This procedure creates the records in pa_project_accum_actuals

2729: RAISE;
2730:
2731: End Insert_Headers_tasks;
2732:
2733: -- This procedure creates the records in pa_project_accum_actuals
2734: -- for all the task break down hierarachy
2735:
2736: Procedure create_accum_actuals
2737: (x_project_id In Number,

Line 2757: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this

2753: Begin
2754: V_Old_Stack := x_err_stack;
2755: x_err_stack :=
2756: x_err_stack||'->PA_PROCESS_ACCUM_ACTUALS.create_accum_actuals';
2757: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this
2758: -- project and task combination. It is possible that there might be a
2759: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
2760: -- no corresponding detail record. The procedure called below,will
2761: -- check for the existence of the detail records and if not available

Line 2814: Insert into PA_PROJECT_ACCUM_ACTUALS (

2810: x_err_stage,
2811: x_err_code);
2812:
2813: Recs_processed := Recs_processed + 1;
2814: Insert into PA_PROJECT_ACCUM_ACTUALS (
2815: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2816: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2817: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2818: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 2887: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this

2883: Begin
2884: V_Old_Stack := x_err_stack;
2885: x_err_stack :=
2886: X_err_stack ||'-PA_MAINT_PROJECT_ACCUM.create_accum_actual_res';
2887: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this
2888: -- project,task and resource combination.It is possible that there might be a
2889: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
2890: -- no corresponding detail record. The procedure called below,will
2891: -- check for the existence of the detail records and if not available

Line 2904: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this

2900: x_err_stage,
2901: x_err_code);
2902: Recs_processed := Recs_processed + Res_recs_processed;
2903:
2904: -- This checks for Actuals record in PA_PROJECT_ACCUM_ACTUALS for this
2905: -- project and Resource combination. It is possible that there might be a
2906: -- header record for this combination in PA_PROJECT_ACCUM_HEADERS, but
2907: -- no corresponding detail record. The procedure called below,will
2908: -- check for the existence of the detail records and if not available

Line 2965: Insert into PA_PROJECT_ACCUM_ACTUALS (

2961: x_err_stage,
2962: x_err_code);
2963: Recs_processed := Recs_processed + 1;
2964:
2965: Insert into PA_PROJECT_ACCUM_ACTUALS (
2966: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
2967: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
2968: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
2969: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 3015: Insert into PA_PROJECT_ACCUM_ACTUALS (

3011: x_err_stage,
3012: x_err_code);
3013:
3014: Recs_processed := Recs_processed + 1;
3015: Insert into PA_PROJECT_ACCUM_ACTUALS (
3016: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,
3017: BILLABLE_RAW_COST_ITD,BILLABLE_RAW_COST_YTD,BILLABLE_RAW_COST_PP,
3018: BILLABLE_RAW_COST_PTD,BURDENED_COST_ITD,BURDENED_COST_YTD,
3019: BURDENED_COST_PP,BURDENED_COST_PTD,BILLABLE_BURDENED_COST_ITD,

Line 3056: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_ACTUALS

3052: RAISE;
3053: End create_accum_actuals_res;
3054:
3055:
3056: -- This Procedure Initializes the figures in the PA_PROJECT_ACCUM_ACTUALS
3057: -- Table. The Initialization will happen in case the current period is
3058: -- greater than the previously accumulated period. The procedure would
3059: -- be called only if the run-mod is 'I' (Incremental) .
3060:

Line 3119: Update PA_PROJECT_ACCUM_ACTUALS SET

3115:
3116: If x_current_start_date > x_prev_accum_start_date then
3117: If X_prev_period = x_prev_accum_period then
3118: If x_current_year > x_prev_accum_year then
3119: Update PA_PROJECT_ACCUM_ACTUALS SET
3120: RAW_COST_YTD = 0,
3121: RAW_COST_PP = RAW_COST_PTD,
3122: RAW_COST_PTD = 0,
3123: BILLABLE_RAW_COST_YTD = 0,

Line 3148: Update PA_PROJECT_ACCUM_ACTUALS SET

3144: Where Project_Accum_id IN
3145: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3146: PAH.Project_Id = x_project_id);
3147: Else
3148: Update PA_PROJECT_ACCUM_ACTUALS SET
3149: RAW_COST_PP = RAW_COST_PTD,
3150: RAW_COST_PTD = 0,
3151: BILLABLE_RAW_COST_PP = BILLABLE_RAW_COST_PTD,
3152: BILLABLE_RAW_COST_PTD = 0,

Line 3176: Update PA_PROJECT_ACCUM_ACTUALS SET

3172: PAH.Project_Id = x_project_id);
3173: End If;
3174: ElsIf X_prev_start_date > x_prev_accum_start_date then
3175: If x_current_year > x_prev_accum_year then
3176: Update PA_PROJECT_ACCUM_ACTUALS SET
3177: RAW_COST_YTD = 0,RAW_COST_PP = 0,
3178: RAW_COST_PTD = 0,
3179: BILLABLE_RAW_COST_YTD = 0,
3180: BILLABLE_RAW_COST_PP =0,

Line 3204: Update PA_PROJECT_ACCUM_ACTUALS SET

3200: Where Project_Accum_id IN
3201: (Select Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH Where
3202: PAH.Project_Id = x_project_id);
3203: Else
3204: Update PA_PROJECT_ACCUM_ACTUALS SET
3205: RAW_COST_PP = 0,
3206: RAW_COST_PTD = 0,
3207: BILLABLE_RAW_COST_PP = 0,
3208: BILLABLE_RAW_COST_PTD = 0,