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_GEN_COMMITMENT_AMOUNTS dependencies on PA_BUDGET_LINES

Line 71: l_txn_cost_rate_override PA_BUDGET_LINES.TXN_COST_RATE_OVERRIDE%TYPE;

67: l_bl_cmt_raw_diff NUMBER:= 0;
68: l_bl_cmt_burden_diff NUMBER:= 0;
69: l_bl_cmt_quantity_diff NUMBER:= 0;
70:
71: l_txn_cost_rate_override PA_BUDGET_LINES.TXN_COST_RATE_OVERRIDE%TYPE;
72: l_burden_cost_rate_override PA_BUDGET_LINES.BURDEN_COST_RATE_OVERRIDE%TYPE;
73: l_proj_cost_exchange_rate PA_BUDGET_LINES.PROJECT_COST_EXCHANGE_RATE%TYPE;
74: l_projfunc_cost_exchange_rate PA_BUDGET_LINES.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
75:

Line 72: l_burden_cost_rate_override PA_BUDGET_LINES.BURDEN_COST_RATE_OVERRIDE%TYPE;

68: l_bl_cmt_burden_diff NUMBER:= 0;
69: l_bl_cmt_quantity_diff NUMBER:= 0;
70:
71: l_txn_cost_rate_override PA_BUDGET_LINES.TXN_COST_RATE_OVERRIDE%TYPE;
72: l_burden_cost_rate_override PA_BUDGET_LINES.BURDEN_COST_RATE_OVERRIDE%TYPE;
73: l_proj_cost_exchange_rate PA_BUDGET_LINES.PROJECT_COST_EXCHANGE_RATE%TYPE;
74: l_projfunc_cost_exchange_rate PA_BUDGET_LINES.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
75:
76: l_appl_id NUMBER;

Line 73: l_proj_cost_exchange_rate PA_BUDGET_LINES.PROJECT_COST_EXCHANGE_RATE%TYPE;

69: l_bl_cmt_quantity_diff NUMBER:= 0;
70:
71: l_txn_cost_rate_override PA_BUDGET_LINES.TXN_COST_RATE_OVERRIDE%TYPE;
72: l_burden_cost_rate_override PA_BUDGET_LINES.BURDEN_COST_RATE_OVERRIDE%TYPE;
73: l_proj_cost_exchange_rate PA_BUDGET_LINES.PROJECT_COST_EXCHANGE_RATE%TYPE;
74: l_projfunc_cost_exchange_rate PA_BUDGET_LINES.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
75:
76: l_appl_id NUMBER;
77: l_cnt NUMBER;

Line 74: l_projfunc_cost_exchange_rate PA_BUDGET_LINES.PROJFUNC_COST_EXCHANGE_RATE%TYPE;

70:
71: l_txn_cost_rate_override PA_BUDGET_LINES.TXN_COST_RATE_OVERRIDE%TYPE;
72: l_burden_cost_rate_override PA_BUDGET_LINES.BURDEN_COST_RATE_OVERRIDE%TYPE;
73: l_proj_cost_exchange_rate PA_BUDGET_LINES.PROJECT_COST_EXCHANGE_RATE%TYPE;
74: l_projfunc_cost_exchange_rate PA_BUDGET_LINES.PROJFUNC_COST_EXCHANGE_RATE%TYPE;
75:
76: l_appl_id NUMBER;
77: l_cnt NUMBER;
78:

Line 204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

200: l_cal_base_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
201: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202:
203: -- budget line amounts for update records
204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

Line 205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

201: l_cal_base_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
202:
203: -- budget line amounts for update records
204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

Line 206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

202:
203: -- budget line amounts for update records
204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

Line 207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

203: -- budget line amounts for update records
204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:

Line 208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

204: l_bl_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

Line 209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

205: l_bl_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

Line 210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

206: l_bl_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
207: l_bl_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

Line 212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

208: l_bl_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

Line 213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

209: l_bl_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

Line 214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

210: l_bl_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:

Line 215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

211:
212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:
219: -- update amounts (existing budget line amounts + commitments)

Line 216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

212: l_bl_init_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:
219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

Line 217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

213: l_bl_txn_init_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
214: l_bl_txn_init_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
215: l_bl_project_init_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:
219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

Line 220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

216: l_bl_pfc_init_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:
219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

Line 221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

217: l_bl_pfc_init_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
218:
219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

Line 222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

218:
219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

Line 223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

219: -- update amounts (existing budget line amounts + commitments)
220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
227:

Line 224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

220: l_upd_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
227:
228: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

Line 225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;

221: l_upd_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
227:
228: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
229: -- stores ids of existing budget lines that need to be deleted

Line 226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;

222: l_upd_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
223: l_upd_project_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
227:
228: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
229: -- stores ids of existing budget lines that need to be deleted
230: -- before Calculate API is called so that a difference is detected.

Line 228: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

224: l_upd_project_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
225: l_upd_pfc_raw_cost PA_BUDGET_LINES.RAW_COST%TYPE;
226: l_upd_pfc_burdened_cost PA_BUDGET_LINES.BURDENED_COST%TYPE;
227:
228: l_budget_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
229: -- stores ids of existing budget lines that need to be deleted
230: -- before Calculate API is called so that a difference is detected.
231: l_budget_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
232:

Line 249: -- Note: these are not valid budget_line_id values in pa_budget_lines.

245: -- Added l_bl_id_counter to track unique budget_line_id values for
246: -- the PA_FP_ROLLUP_TMP table. Initialize it to the MAX budget_line_id
247: -- value in the temp table to pick up where the Staffing Plan API left
248: -- off, and increment by 1 prior to each Insert to the temp table.
249: -- Note: these are not valid budget_line_id values in pa_budget_lines.
250: -- Rather, we are using the column to index records for processing of
251: -- cost-based revenue amounts, since an Index exists for the column.
252: l_bl_id_counter NUMBER;
253:

Line 259: -- or in PA_BUDGET_LINES for other cases), a generic error message will be

255: l_billable_flag VARCHAR2(1);
256:
257: -- Bug 4549862: Whenever Commitments map to a resource having rejection
258: -- code data (either in PA_FP_ROLLUP_TMP when the source is Staffing Plan,
259: -- or in PA_BUDGET_LINES for other cases), a generic error message will be
260: -- added once to the error stack. For each such commitment, the relevant
261: -- rejection code values should be added to the error stack. After all
262: -- Commitments have been processed, an error should be raised. This flag
263: -- tracks if at least 1 commitment maps to a resource having rejection

Line 764: -- When l_cost_based_all_from_sp_flag = 'N', check PA_BUDGET_LINES

760:
761: -- Bug 4549862: Now that we have the commitment period start date
762: -- for timephased versions, get budget line rejection codes.
763: --
764: -- When l_cost_based_all_from_sp_flag = 'N', check PA_BUDGET_LINES
765: -- for rejection codes. When l_cost_based_all_from_sp_flag = 'Y',
766: -- check PA_FP_ROLLUP_TMP for rejection codes instead.
767: -- We are only interested in checking the raw cost, burden cost,
768: -- pc/pfc currency conversion rejection codes.

Line 784: FROM pa_budget_lines

780: l_cost_rej_code_tab,
781: l_burden_rej_code_tab,
782: l_pc_cur_conv_rej_code_tab,
783: l_pfc_cur_conv_rej_code_tab
784: FROM pa_budget_lines
785: WHERE resource_assignment_id = l_res_asg_id(i)
786: AND txn_currency_code = l_currency_code(i)
787: AND start_date = l_bl_start_date
788: AND ( cost_rejection_code is not null OR

Line 804: FROM pa_budget_lines

800: l_cost_rej_code_tab,
801: l_burden_rej_code_tab,
802: l_pc_cur_conv_rej_code_tab,
803: l_pfc_cur_conv_rej_code_tab
804: FROM pa_budget_lines
805: WHERE resource_assignment_id = l_res_asg_id(i)
806: AND txn_currency_code = l_currency_code(i)
807: AND ( cost_rejection_code is not null OR
808: burden_rejection_code is not null OR

Line 978: -- pa_budget_lines for further processing. At the same time, we

974: -- Bug 4549862: For the Cost-based All version from Staffing Plan
975: -- flow, we do not need to check if a budget line exists for the
976: -- current commitment being processed, since we will be inserting
977: -- the commitment data into the PA_FP_ROLLUP_TMP table instead of
978: -- pa_budget_lines for further processing. At the same time, we
979: -- still want the l_budget_lines_exist flag initialized as 'N' so
980: -- that logic for updating dates for None time phased versions is
981: -- still executed properly.
982:

Line 1005: FROM PA_BUDGET_LINES BL

1001: l_bl_project_raw_cost,
1002: l_bl_project_burdened_cost,
1003: l_bl_pfc_raw_cost,
1004: l_bl_pfc_burdened_cost
1005: FROM PA_BUDGET_LINES BL
1006: WHERE BL.RESOURCE_ASSIGNMENT_ID = l_res_asg_id(i)
1007: AND BL.TXN_CURRENCY_CODE = l_currency_code(i)
1008: AND BL.START_DATE = l_bl_start_date;
1009: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN

Line 1043: FROM PA_BUDGET_LINES BL

1039: l_bl_txn_init_burdened_cost,
1040: l_bl_project_init_raw_cost,
1041: l_bl_pfc_init_raw_cost,
1042: l_bl_pfc_init_burdened_cost
1043: FROM PA_BUDGET_LINES BL
1044: WHERE BL.RESOURCE_ASSIGNMENT_ID = l_res_asg_id(i)
1045: AND BL.TXN_CURRENCY_CODE = l_currency_code(i);
1046: ELSE
1047: SELECT BUDGET_LINE_ID,

Line 1067: FROM PA_BUDGET_LINES BL

1063: l_bl_project_raw_cost,
1064: l_bl_project_burdened_cost,
1065: l_bl_pfc_raw_cost,
1066: l_bl_pfc_burdened_cost
1067: FROM PA_BUDGET_LINES BL
1068: WHERE BL.RESOURCE_ASSIGNMENT_ID = l_res_asg_id(i)
1069: AND BL.TXN_CURRENCY_CODE = l_currency_code(i);
1070: END IF; -- Forecast plan check
1071: END IF; -- time phase check

Line 1085: -- the None time phase case to avoid an extra query to pa_budget_lines.

1081: END IF; -- l_cost_based_all_from_sp_flag check
1082:
1083:
1084: -- We have delayed processing on l_bl_start_date and l_bl_end_date for
1085: -- the None time phase case to avoid an extra query to pa_budget_lines.
1086: IF ( P_FP_COLS_REC.X_TIME_PHASED_CODE = 'N' )
1087: THEN
1088: -- Since start_date and end_date are both non-null columns in
1089: -- pa_budget_lines, checking l_bl_start_date is sufficient.

Line 1089: -- pa_budget_lines, checking l_bl_start_date is sufficient.

1085: -- the None time phase case to avoid an extra query to pa_budget_lines.
1086: IF ( P_FP_COLS_REC.X_TIME_PHASED_CODE = 'N' )
1087: THEN
1088: -- Since start_date and end_date are both non-null columns in
1089: -- pa_budget_lines, checking l_bl_start_date is sufficient.
1090: IF l_bl_start_date IS NOT NULL THEN
1091: IF l_reference_start_date < l_bl_start_date THEN
1092: l_bl_start_date := l_reference_start_date;
1093: END IF;

Line 1106: -- instead of pa_budget_lines for further processing by the Cost-

1102:
1103:
1104: -- Bug 4549862: For the Cost-based All version from Staffing Plan
1105: -- flow, Insert commitment data into the PA_FP_ROLLUP_TMP table
1106: -- instead of pa_budget_lines for further processing by the Cost-
1107: -- based Revenue Generation API, which will propagate the data to
1108: -- the budget lines. For all other flows, proceed with existing
1109: -- logic for Insert/Update to the budget lines.
1110:

Line 1213: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,

1209: l_proj_cost_exchange_rate := l_proj_raw_cost_sum(i) / l_raw_cost_sum(i);
1210: l_projfunc_cost_exchange_rate := l_projfunc_raw_cost_sum(i) / l_raw_cost_sum(i);
1211: END IF;
1212:
1213: INSERT INTO PA_BUDGET_LINES(RESOURCE_ASSIGNMENT_ID,
1214: START_DATE,
1215: END_DATE,
1216: PERIOD_NAME,
1217: TXN_CURRENCY_CODE,

Line 1253: pa_budget_lines_s.nextval,

1249: l_proj_burdened_cost_sum(i),
1250: l_projfunc_raw_cost_sum(i),
1251: l_projfunc_burdened_cost_sum(i),
1252: l_quantity_sum_tab(i),
1253: pa_budget_lines_s.nextval,
1254: p_budget_version_id,
1255: p_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
1256: p_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE,
1257: l_sysdate,

Line 1291: ---if the record does exist then update the record in the pa_budget_lines table

1287: | of Revenue amounts. This requires that we have budget lines populated.|
1288: | Therefore, still do the Update. |
1289: +====================================================================================*/
1290:
1291: ---if the record does exist then update the record in the pa_budget_lines table
1292: IF l_calc_api_required_flag = 'Y' AND
1293: p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1294: -- These budget lines will be deleted before calling Calculate
1295: bl_index := bl_index + 1;

Line 1366: UPDATE PA_BUDGET_LINES

1362: dbms_output.put_line('Start_date: '||l_bl_start_date);*/
1363:
1364:
1365: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1366: UPDATE PA_BUDGET_LINES
1367: SET LAST_UPDATE_DATE = l_sysdate
1368: , LAST_UPDATED_BY = l_last_updated_by
1369: , LAST_UPDATE_LOGIN = l_last_update_login
1370: -- , START_DATE = l_bl_start_date

Line 1387: UPDATE PA_BUDGET_LINES

1383: , project_cost_exchange_rate = l_proj_cost_exchange_rate
1384: , projfunc_cost_exchange_rate = l_projfunc_cost_exchange_rate
1385: WHERE BUDGET_LINE_ID = l_budget_line_id;
1386: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1387: UPDATE PA_BUDGET_LINES
1388: SET LAST_UPDATE_DATE = l_sysdate
1389: , LAST_UPDATED_BY = l_last_updated_by
1390: , LAST_UPDATE_LOGIN = l_last_update_login
1391: , START_DATE = l_bl_start_date

Line 1883: DELETE FROM PA_BUDGET_LINES

1879: -- Since the source context is Budget Line, before calling the Calculate
1880: -- API, we need to delete existing budget lines for which we need to
1881: -- populate Commitment amounts.
1882: FORALL i IN 1.. l_budget_line_id_tab.count
1883: DELETE FROM PA_BUDGET_LINES
1884: WHERE budget_line_id = l_budget_line_id_tab(i);
1885:
1886: -- Bug 4582616 Step 4: Delete Raw Cost and Burdened Cost Rates from
1887: -- the PA_FP_GEN_RATE_TMP table since we only want the Calculate API