163: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
164:
165: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
166: (
167: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
164:
165: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
166: (
167: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
165: PROCEDURE GET_OR_CREATE_AMOUNT_SET_ID
166: (
167: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
166: (
167: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
174: /* Changes for FP.M, Tracking Bug No - 3354518
167: p_raw_cost_flag IN pa_fin_plan_amount_sets.raw_cost_flag%TYPE,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
174: /* Changes for FP.M, Tracking Bug No - 3354518
175: Adding three new IN parameters p_bill_rate_flag,
168: p_burdened_cost_flag IN pa_fin_plan_amount_sets.burdened_cost_flag%TYPE,
169: p_revenue_flag IN pa_fin_plan_amount_sets.revenue_flag%TYPE,
170: p_cost_qty_flag IN pa_fin_plan_amount_sets.cost_qty_flag%TYPE,
171: p_revenue_qty_flag IN pa_fin_plan_amount_sets.revenue_qty_flag%TYPE,
172: p_all_qty_flag IN pa_fin_plan_amount_sets.all_qty_flag%TYPE,
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
174: /* Changes for FP.M, Tracking Bug No - 3354518
175: Adding three new IN parameters p_bill_rate_flag,
176: p_cost_rate_flag, p_burden_rate below for
173: p_plan_pref_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE,
174: /* Changes for FP.M, Tracking Bug No - 3354518
175: Adding three new IN parameters p_bill_rate_flag,
176: p_cost_rate_flag, p_burden_rate below for
177: new columns in pa_fin_plan_amount_sets */
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
174: /* Changes for FP.M, Tracking Bug No - 3354518
175: Adding three new IN parameters p_bill_rate_flag,
176: p_cost_rate_flag, p_burden_rate below for
177: new columns in pa_fin_plan_amount_sets */
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
175: Adding three new IN parameters p_bill_rate_flag,
176: p_cost_rate_flag, p_burden_rate below for
177: new columns in pa_fin_plan_amount_sets */
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
183: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
176: p_cost_rate_flag, p_burden_rate below for
177: new columns in pa_fin_plan_amount_sets */
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
183: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
184: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
177: new columns in pa_fin_plan_amount_sets */
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
183: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
184: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
178: p_bill_rate_flag IN pa_fin_plan_amount_sets.bill_rate_flag%TYPE,
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
183: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
184: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_message_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
179: p_cost_rate_flag IN pa_fin_plan_amount_sets.cost_rate_flag%TYPE,
180: p_burden_rate_flag IN pa_fin_plan_amount_sets.burden_rate_flag%TYPE,
181: x_cost_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
182: x_revenue_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
183: x_all_amount_set_id OUT NOCOPY pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE, --File.Sql.39 bug 4440895
184: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
185: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
186: x_message_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
187: );
186: x_message_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
187: );
188:
189: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
190: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
187: );
188:
189: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
190: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
188:
189: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
190: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
189: PROCEDURE GET_PLAN_AMOUNT_FLAGS(
190: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
190: P_AMOUNT_SET_ID IN PA_FIN_PLAN_AMOUNT_SETS.fin_plan_amount_set_id%TYPE,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
198: Adding three new OUT parameters x_bill_rate_flag,
191: X_RAW_COST_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.raw_cost_flag%TYPE, --File.Sql.39 bug 4440895
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
198: Adding three new OUT parameters x_bill_rate_flag,
199: x_cost_rate_flag, x_burden_rate below for
192: X_BURDENED_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.burdened_cost_flag%TYPE, --File.Sql.39 bug 4440895
193: X_REVENUE_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_flag%TYPE, --File.Sql.39 bug 4440895
194: X_COST_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.cost_qty_flag%TYPE, --File.Sql.39 bug 4440895
195: X_REV_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.revenue_qty_flag%TYPE, --File.Sql.39 bug 4440895
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
198: Adding three new OUT parameters x_bill_rate_flag,
199: x_cost_rate_flag, x_burden_rate below for
200: new columns in pa_fin_plan_amount_sets */
196: X_ALL_QUANTITY_FLAG OUT NOCOPY PA_FIN_PLAN_AMOUNT_SETS.all_qty_flag%TYPE, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
198: Adding three new OUT parameters x_bill_rate_flag,
199: x_cost_rate_flag, x_burden_rate below for
200: new columns in pa_fin_plan_amount_sets */
201: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
202: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
203: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
204: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
197: /* Changes for FP.M, Tracking Bug No - 3354518
198: Adding three new OUT parameters x_bill_rate_flag,
199: x_cost_rate_flag, x_burden_rate below for
200: new columns in pa_fin_plan_amount_sets */
201: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
202: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
203: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
204: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
205: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
198: Adding three new OUT parameters x_bill_rate_flag,
199: x_cost_rate_flag, x_burden_rate below for
200: new columns in pa_fin_plan_amount_sets */
201: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
202: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
203: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
204: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
205: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
206: x_message_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
199: x_cost_rate_flag, x_burden_rate below for
200: new columns in pa_fin_plan_amount_sets */
201: X_BILL_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.bill_rate_flag%TYPE, --File.Sql.39 bug 4440895
202: X_COST_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.cost_rate_flag%TYPE, --File.Sql.39 bug 4440895
203: X_BURDEN_RATE_FLAG OUT NOCOPY pa_fin_plan_amount_sets.burden_rate_flag%TYPE, --File.Sql.39 bug 4440895
204: x_message_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
205: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
206: x_message_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
207: