DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PVT dependencies on PA_PJT_WBS_FACT

Line 3362: UPDATE pa_pjt_wbs_fact fact /* bulk bind */

3358:
3359: ppr_log(' p_calling_mode = CREATE and p_fact_slice = WBS');
3360:
3361: FORALL i IN 1..p_fact_task_arr.count
3362: UPDATE pa_pjt_wbs_fact fact /* bulk bind */
3363: SET (
3364: ----
3365: RAW_COST, BRDN_COST, REVENUE
3366: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3427: UPDATE pa_pjt_wbs_fact fact /* bulk bind */

3423:
3424: elsif ( p_calling_mode = 'INCREMENTAL' and p_fact_slice = 'WBS' ) then
3425:
3426: FORALL i IN 1..p_fact_task_arr.count
3427: UPDATE pa_pjt_wbs_fact fact /* bulk bind */
3428: SET (
3429: ----
3430: RAW_COST, BRDN_COST, REVENUE
3431: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3883: INSERT INTO pa_pjt_wbs_fact (

3879:
3880: ppr_log(' p_fact_slice = WBS');
3881:
3882: FORALL i IN 1..p_fact_task_arr.count
3883: INSERT INTO pa_pjt_wbs_fact (
3884: ----
3885: PROJECT_ID , PROJECT_ELEMENT_ID
3886: ,WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG,CURRENCY_CODE --,RBS_ELEMENT_ID, RBS_VERSION_ID
3887: , PLAN_VERSION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN