APPS.PA_PLAN_MATRIX dependencies on PA_PROJ_PERIODS_DENORM

Line 2811: -- POPULATION OF PA_PROJ_PERIODS_DENORM

2807: /* these variables needs to be set for each amount type and
2808: currency type, otherwise it will lead to element at
2809: index [X] does not exist */
2810: IF (l_quantity_filter_flag = 'Y') THEN
2811: -- POPULATION OF PA_PROJ_PERIODS_DENORM
2812: -- Storing current amount values from denorm table
2813: IF (main_cur_rec.currency_type = 'TRANSACTION' OR p_calling_module = 'ORG_FORECAST') THEN
2814: BEGIN
2815: SELECT Period_Amount1,

Line 2921: FROM pa_proj_periods_denorm

2917: l_pd_amt50 ,
2918: l_pd_amt51 ,
2919: l_pd_amt52,
2920: l_parent_assignment_id
2921: FROM pa_proj_periods_denorm
2922: WHERE period_profile_id = p_period_profile_id AND
2923: Budget_Version_Id = p_budget_version_id AND
2924: project_id = p_project_id AND
2925: Resource_Assignment_Id = l_res_asg_id AND

Line 3098: FROM pa_proj_periods_denorm

3094: l_pd_amt50 ,
3095: l_pd_amt51 ,
3096: l_pd_amt52,
3097: l_parent_assignment_id
3098: FROM pa_proj_periods_denorm
3099: WHERE period_profile_id = p_period_profile_id AND
3100: Budget_Version_Id = p_budget_version_id AND
3101: project_id = p_project_id AND
3102: Resource_Assignment_Id = l_res_asg_id AND

Line 3329: UPDATE Pa_Proj_Periods_Denorm SET

3325: -- Added by Vijay s Gautam
3326:
3327: IF (main_cur_rec.currency_type = 'TRANSACTION' OR p_calling_module = 'ORG_FORECAST') THEN
3328: --
3329: UPDATE Pa_Proj_Periods_Denorm SET
3330: preceding_periods_amount = l_prev_amt,
3331: succeeding_periods_amount = l_next_amt,
3332: prior_period_amount = l_prior_amt,
3333: period_amount1 = l_pd_amt1,

Line 3476: UPDATE Pa_Proj_Periods_Denorm SET

3472:
3473: ELSE
3474: /* for currency type other than transaction */
3475: BEGIN
3476: UPDATE Pa_Proj_Periods_Denorm SET
3477: preceding_periods_amount = l_prev_amt,
3478: succeeding_periods_amount = l_next_amt,
3479: prior_period_amount = l_prior_amt,
3480: period_amount1 = NVL(period_amount1,0) + l_pd_amt1,

Line 3547: INSERT INTO Pa_Proj_Periods_Denorm

3543: Amount_Subtype_Code = l_amt_subtype_code AND
3544: Currency_Type = l_currency_type AND
3545: Currency_Code = l_currency_code;
3546: IF SQL%ROWCOUNT = 0 THEN
3547: INSERT INTO Pa_Proj_Periods_Denorm
3548: ( CREATION_DATE ,
3549: CREATED_BY ,
3550: LAST_UPDATE_LOGIN ,
3551: LAST_UPDATED_BY ,

Line 3736: INSERT INTO Pa_Proj_Periods_Denorm(

3732: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
3733: END IF;
3734:
3735: FORALL l_ins_temp IN 1 .. l_amount_tab50.count
3736: INSERT INTO Pa_Proj_Periods_Denorm(
3737: CREATION_DATE ,
3738: CREATED_BY ,
3739: LAST_UPDATE_LOGIN ,
3740: LAST_UPDATED_BY ,