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_PPR_ROLLUP_PVT dependencies on PA_PJT_WBS_RBS_CBS_FACT

Line 2880: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

2876:
2877: ppr_log(' p_calling_mode = CREATE and ( p_fact_slice = CBS_TO_RBS and CBS_TO_WBS )');
2878:
2879: FORALL i IN 1..p_fact_task_arr.count
2880: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
2881: SET (
2882: ----
2883: RAW_COST, BRDN_COST, REVENUE
2884: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 2962: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

2958: elsif ( p_calling_mode = 'INCREMENTAL' and ( p_fact_slice = 'CBS_TO_RBS' or p_fact_slice = 'CBS_TO_WBS' or p_fact_slice = 'WBS_TO_CBS_TO_RBS' ) ) then
2959:
2960:
2961: FORALL i IN 1..p_fact_task_arr.count
2962: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
2963: SET (
2964: ----
2965: RAW_COST, BRDN_COST, REVENUE
2966: , bill_RAW_COST, bill_BRDN_COST

Line 3048: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

3044:
3045: ppr_log(' p_calling_mode = CREATE and ( p_fact_slice = RBS_TO_WBS )');
3046:
3047: FORALL i IN 1..p_fact_task_arr.count
3048: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
3049: SET (
3050: ----
3051: RAW_COST, BRDN_COST, REVENUE
3052: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3117: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

3113:
3114: ppr_log(' p_calling_mode = INCREMENTAL and ( p_fact_slice = RBS_TO_WBS )');
3115:
3116: FORALL i IN 1..p_fact_task_arr.count
3117: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
3118: SET (
3119: ----
3120: RAW_COST, BRDN_COST, REVENUE
3121: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3188: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

3184:
3185: ppr_log(' p_calling_mode = CREATE and ( p_fact_slice = WBS_TO_RBS or p_fact_slice = WBS_TO_CBS )');
3186:
3187: FORALL i IN 1..p_fact_task_arr.count
3188: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
3189: SET (
3190: ----
3191: RAW_COST, BRDN_COST, REVENUE
3192: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3274: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */

3270:
3271: ppr_log(' p_calling_mode = INCREMENTAL and ( p_fact_slice = WBS_TO_RBS or p_fact_slice = WBS_TO_CBS )');
3272:
3273: FORALL i IN 1..p_fact_task_arr.count
3274: UPDATE pa_pjt_wbs_rbs_cbs_fact fact /* bulk bind */
3275: SET (
3276: ----
3277: RAW_COST, BRDN_COST, REVENUE
3278: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3672: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (

3668: ppr_log(' p_fact_slice '||p_fact_slice);
3669:
3670:
3671: FORALL i IN 1..p_fact_task_arr.count
3672: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (
3673: ----
3674: PROJECT_ID , PROJECT_ELEMENT_ID
3675: , RBS_AGGR_LEVEL , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG,CURRENCY_CODE --,RBS_ELEMENT_ID, RBS_VERSION_ID
3676: , PLAN_VERSION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN

Line 3742: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (

3738:
3739: ppr_log(' SRIDHAR .... p_fact_task_arr '||p_fact_task_arr.count);
3740:
3741: FORALL i IN 1..p_fact_task_arr.count
3742: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (
3743: ----
3744: PROJECT_ID , PROJECT_ELEMENT_ID
3745: , RBS_AGGR_LEVEL , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG,CURRENCY_CODE --,RBS_ELEMENT_ID, RBS_VERSION_ID
3746: , PLAN_VERSION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN

Line 3813: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (

3809: ppr_log(' p_fact_slice =WBS_TO_RBS or WBS_TO_CBS ');
3810:
3811:
3812: FORALL i IN 1..p_fact_task_arr.count
3813: INSERT INTO pa_pjt_wbs_rbs_cbs_fact (
3814: ----
3815: PROJECT_ID , PROJECT_ELEMENT_ID
3816: , RBS_AGGR_LEVEL , WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG,CURRENCY_CODE --,RBS_ELEMENT_ID, RBS_VERSION_ID
3817: , PLAN_VERSION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN