DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PVT dependencies on PA_PJT_RBS_CBS_FACT

Line 3496: UPDATE pa_pjt_rbs_cbs_fact fact /* bulk bind */

3492: elsif ( p_calling_mode = 'CREATE' and ( p_fact_slice = 'RBS' or p_fact_slice = 'CBS') ) then
3493:
3494:
3495: FORALL i IN 1..p_fact_task_arr.count
3496: UPDATE pa_pjt_rbs_cbs_fact fact /* bulk bind */
3497: SET (
3498: ----
3499: RAW_COST, BRDN_COST, REVENUE
3500: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3563: UPDATE pa_pjt_rbs_cbs_fact fact /* bulk bind */

3559:
3560: elsif ( p_calling_mode = 'INCREMENTAL' and ( p_fact_slice = 'RBS' or p_fact_slice = 'CBS') ) then
3561:
3562: FORALL i IN 1..p_fact_task_arr.count
3563: UPDATE pa_pjt_rbs_cbs_fact fact /* bulk bind */
3564: SET (
3565: ----
3566: RAW_COST, BRDN_COST, REVENUE
3567: , bill_RAW_COST, bill_BRDN_COST, bill_LABOR_RAW_COST, bill_LABOR_BRDN_COST

Line 3947: INSERT INTO pa_pjt_rbs_cbs_fact (

3943:
3944: ppr_log(' p_fact_slice = RBS or CBS ');
3945:
3946: FORALL i IN 1..p_fact_task_arr.count
3947: INSERT INTO pa_pjt_rbs_cbs_fact (
3948: ----
3949: PROJECT_ID , ROLLUP_TYPE
3950: , RBS_AGGR_LEVEL , PRG_ROLLUP_FLAG,CURRENCY_CODE,RBS_CBS_ELEMENT_ID, RBS_CBS_VERSION_ID
3951: , PLAN_VERSION_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN