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_FP_EDIT_LINE_PKG dependencies on PA_PROJ_PERIODS_DENORM

Line 720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

716: l_msg_index_out NUMBER;
717: l_debug_mode VARCHAR2(10);
718: l_stage NUMBER := 100;
719:
720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

717: l_debug_mode VARCHAR2(10);
718: l_stage NUMBER := 100;
719:
720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

718: l_stage NUMBER := 100;
719:
720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

719:
720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

720: l_preceding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:

Line 725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

721: l_succeeding_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;

722: l_preceding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;

723: l_succeeding_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
724: l_preceding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

725: l_succeeding_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

726: l_preceding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

727: l_succeeding_quantity pa_proj_periods_denorm.preceding_periods_amount%TYPE;
728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

728:
729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

729: l_pd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

730: l_pd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

731: l_sd_pc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;

732: l_sd_pfc_raw_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

Line 737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

733: l_pd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
741:

Line 738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

734: l_pd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
741:
742: l_preceding_period_text fnd_new_messages.message_text%TYPE := fnd_message.GET_STRING('PA','PA_FP_PREC_PERIOD_AMOUNT');

Line 739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

735: l_sd_pc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
741:
742: l_preceding_period_text fnd_new_messages.message_text%TYPE := fnd_message.GET_STRING('PA','PA_FP_PREC_PERIOD_AMOUNT');
743: l_succeeding_period_text fnd_new_messages.message_text%TYPE := fnd_message.GET_STRING('PA','PA_FP_SUCC_PERIOD_AMOUNT');

Line 740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;

736: l_sd_pfc_burdened_cost pa_proj_periods_denorm.preceding_periods_amount%TYPE;
737: l_pd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
738: l_pd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
739: l_sd_pc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
740: l_sd_pfc_revenue pa_proj_periods_denorm.preceding_periods_amount%TYPE;
741:
742: l_preceding_period_text fnd_new_messages.message_text%TYPE := fnd_message.GET_STRING('PA','PA_FP_PREC_PERIOD_AMOUNT');
743: l_succeeding_period_text fnd_new_messages.message_text%TYPE := fnd_message.GET_STRING('PA','PA_FP_SUCC_PERIOD_AMOUNT');
744:

Line 2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895

2399: ,x_bill_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE --File.Sql.39 bug 4440895
2400: ,x_cost_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE --File.Sql.39 bug 4440895
2401: ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
2402: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
2403: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
2404: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
2405: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2406: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
2407: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

Line 3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3220: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3221: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3222: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3223: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3224: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3225: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3226: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3227: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3228: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3229: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3230: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3238: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3231: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3232: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3233: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3234: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3235: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3236: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3237: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3238: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3239:

Line 3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3401: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3402: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3403: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3404: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

Line 3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3405: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3406: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3407: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3415: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

3408: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3409: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3410: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3411: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3412: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
3413: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3414: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3415: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
3416:

Line 3427: FROM pa_proj_periods_denorm

3423: SELECT amount_type_code
3424: ,amount_subtype_code
3425: ,preceding_periods_amount
3426: ,succeeding_periods_amount
3427: FROM pa_proj_periods_denorm
3428: WHERE budget_version_id = p_budget_version_id
3429: AND resource_assignment_id = p_resource_assignment_id
3430: AND object_type_code = PA_FP_CONSTANTS_PKG.G_OBJECT_TYPE_RES_ASSIGNMENT
3431: AND object_id = p_resource_assignment_id

Line 4044: in pa_resource_assignments and pa_proj_periods_denorm.

4040:
4041: /*=================================================================================================
4042: This api will do the final processing of budget lines data for a budget version. The processing
4043: includes computing the MC amounts, creating MRC lines if required and rolling budget lines data
4044: in pa_resource_assignments and pa_proj_periods_denorm.
4045: This API does not do maintenance of plan amount exist flag on pa_fp_elements because as of now
4046: this process does not create budget lines. The maintenance of the flag should be done from the
4047: place where budget lines are created always.
4048: =================================================================================================*/