DBA Data[Home] [Help]

APPS.PA_FP_EDIT_LINE_PKG dependencies on PA_PROJ_PERIODS_DENORM

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

55: ,x_bill_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE --File.Sql.39 bug 4440895
56: ,x_cost_rate_flag OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE --File.Sql.39 bug 4440895
57: ,x_burden_multiplier_flag OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE --File.Sql.39 bug 4440895
58: /* Changes for FP.M, Tracking Bug No - 3354518. End here*/
59: ,x_period_profile_id OUT NOCOPY pa_proj_periods_denorm.PERIOD_PROFILE_ID%TYPE --File.Sql.39 bug 4440895
60: ,x_plan_period_type OUT NOCOPY pa_proj_period_profiles.PLAN_PERIOD_TYPE%TYPE --File.Sql.39 bug 4440895
61: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
62: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.RAW_COST%TYPE --File.Sql.39 bug 4440895
63: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.BURDENED_COST%TYPE --File.Sql.39 bug 4440895

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

107: p_budget_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE -- Added for #2839138
108: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
109: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
110: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

108: ,p_resource_assignment_id IN pa_resource_assignments.RESOURCE_ASSIGNMENT_ID%TYPE
109: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
110: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

109: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
110: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

110: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

111: ,x_preceding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
119: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

112: ,x_succeeding_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
119: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

113: ,x_preceding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
119: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895

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

114: ,x_succeeding_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
115: ,x_preceding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
116: ,x_succeeding_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
117: ,x_preceding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
118: ,x_succeeding_quantity OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
119: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: ,x_msg_data OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
122:

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

151: PROCEDURE GET_PD_SD_AMT_IN_PC_PFC(
152: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
153: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
154: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

152: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
153: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
154: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

153: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
154: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

154: ,p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE
155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

155: ,x_pd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

156: ,x_pd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

157: ,x_sd_pc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

158: ,x_sd_pfc_raw_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895

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

159: ,x_pd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
167: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

160: ,x_pd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
167: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

161: ,x_sd_pc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
167: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
169: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

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

162: ,x_sd_pfc_burdened_cost OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
163: ,x_pd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
164: ,x_pd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
165: ,x_sd_pc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
166: ,x_sd_pfc_revenue OUT NOCOPY pa_proj_periods_denorm.preceding_periods_amount%TYPE --File.Sql.39 bug 4440895
167: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
168: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
169: ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
170: