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

Line 153: pa_budget_lines sbl,

149: NULL,
150: NULL,
151: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
152: FROM pa_res_list_map_tmp4 tmp4,
153: pa_budget_lines sbl,
154: pa_resource_assignments ra,
155: pa_tasks ta /* Added for ER 4376722 */
156: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
157: and sbl.budget_version_id = l_source_id

Line 186: FROM pa_budget_lines

182: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
183: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
184: ) IS
185: SELECT sum(nvl(init_quantity,0))
186: FROM pa_budget_lines
187: WHERE resource_assignment_id = c_res_asgn_id
188: AND txn_currency_code = c_txn_currency_code;
189:
190: l_total_plan_qty NUMBER;

Line 202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

198: l_calling_context VARCHAR2(30);
199:
200: /* Pro-rate API variables */
201: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

Line 203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

199:
200: /* Pro-rate API variables */
201: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

Line 204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

200: /* Pro-rate API variables */
201: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;

Line 205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;

201: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
209:

Line 206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

202: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
209:
210: /* This cursor is the revenue forecast generation analogue of the cursor

Line 207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

203: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
209:
210: /* This cursor is the revenue forecast generation analogue of the cursor
211: * budget_line_src_to_cal. As such, changes to that cursor should likely be

Line 208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;

204: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
205: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
206: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
207: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
208: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
209:
210: /* This cursor is the revenue forecast generation analogue of the cursor
211: * budget_line_src_to_cal. As such, changes to that cursor should likely be
212: * mirorred here. See comments above the other cursor for more info.

Line 253: pa_budget_lines sbl,

249: NULL,
250: NULL,
251: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
252: FROM pa_res_list_map_tmp4 tmp4,
253: pa_budget_lines sbl,
254: pa_resource_assignments ra,
255: pa_tasks ta /* Added for ER 4376722 */
256: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
257: and sbl.budget_version_id = l_source_id

Line 324: pa_budget_lines sbl,

320: NULL,
321: NULL,
322: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
323: FROM pa_res_list_map_tmp4 tmp4,
324: pa_budget_lines sbl,
325: pa_resource_assignments ra,
326: pa_tasks ta /* Added for ER 4376722 */
327: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
328: and sbl.budget_version_id = l_source_id

Line 1323: DELETE FROM pa_budget_lines bl

1319: * must Delete (non-actuals) budget lines for resources that are not
1320: * manually added/edited. */
1321: IF p_retain_manual_flag = 'Y' THEN
1322: IF l_calling_context = lc_BudgetGeneration THEN
1323: DELETE FROM pa_budget_lines bl
1324: WHERE budget_version_id = p_budget_version_id
1325: AND EXISTS
1326: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1327: FROM pa_res_list_map_tmp4 tmp

Line 1334: DELETE FROM pa_budget_lines bl

1330: ELSIF l_calling_context = lc_ForecastGeneration THEN
1331: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
1332: ( p_budget_version_id );
1333: IF l_fp_cols_rec_target.x_time_phased_code IN ('P','G') THEN
1334: DELETE FROM pa_budget_lines bl
1335: WHERE budget_version_id = p_budget_version_id
1336: AND EXISTS
1337: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1338: FROM pa_res_list_map_tmp4 tmp

Line 1347: *unique identifiers for pa_budget_lines:

1343: END IF;
1344: END IF; -- end budget line deletion
1345:
1346: /**Populating target budget lines by summing up the values.
1347: *unique identifiers for pa_budget_lines:
1348: *1.resource_assignment_id : corresponds to one budget_version_id;
1349: *=one planning element; rlmID from pa_resource_assignment
1350: *2.currency
1351: *3.start_date**/

Line 1459: FROM pa_Budget_lines bl,

1455: l_src_revenue_tab,
1456: l_cost_rate_override_tab,
1457: l_b_cost_rate_override_tab,
1458: l_bill_rate_override_tab
1459: FROM pa_Budget_lines bl,
1460: pa_resource_assignments ra
1461: WHERE bl.budget_version_id = p_budget_version_id
1462: AND ra.budget_version_id = p_budget_version_id
1463: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 2588: pa_budget_lines where

2584: FOR k IN 1 .. l_tgt_res_asg_id_tab.COUNT LOOP
2585: BEGIN
2586: SELECT sum(init_quantity),sum(init_revenue) into
2587: l_calc_qty_tmp, l_calc_tmp_rev FROM
2588: pa_budget_lines where
2589: resource_assignment_id = l_tgt_res_asg_id_tab(k) AND
2590: txn_currency_code = l_txn_currency_code_tab(k);
2591: EXCEPTION
2592: WHEN NO_DATA_FOUND THEN

Line 2821: pa_budget_lines sbl,

2817: NULL,
2818: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2819: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2820: FROM pa_res_list_map_tmp4 tmp4,
2821: pa_budget_lines sbl,
2822: pa_resource_assignments ra,
2823: pa_tasks ta /* Added for ER 4376722 */
2824: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2825: and sbl.budget_version_id = p_source_bv_id

Line 2910: pa_budget_lines sbl,

2906: NULL,
2907: NULL,
2908: NVL(ta.billable_flag,'Y')
2909: FROM pa_res_list_map_tmp4 tmp4,
2910: pa_budget_lines sbl,
2911: pa_resource_assignments ra,
2912: pa_tasks ta
2913: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2914: and sbl.budget_version_id = p_source_bv_id

Line 3006: pa_budget_lines sbl,

3002: NULL,
3003: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3004: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3005: FROM pa_res_list_map_tmp4 tmp4,
3006: pa_budget_lines sbl,
3007: pa_resource_assignments ra,
3008: pa_tasks ta /* Added for ER 4376722 */
3009: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3010: and sbl.budget_version_id = p_source_bv_id

Line 3103: pa_budget_lines sbl,

3099: NULL,
3100: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3101: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3102: FROM pa_res_list_map_tmp4 tmp4,
3103: pa_budget_lines sbl,
3104: pa_resource_assignments ra,
3105: pa_tasks ta /* Added for ER 4376722 */
3106: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3107: and sbl.budget_version_id = p_source_bv_id

Line 3140: FROM pa_budget_lines

3136: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3137: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3138: ) IS
3139: SELECT sum(nvl(init_quantity,0))
3140: FROM pa_budget_lines
3141: WHERE resource_assignment_id = c_res_asgn_id
3142: AND txn_currency_code = c_txn_currency_code;
3143:
3144: /* Additional types and variables added for Bug 4938603 */

Line 3146: IS TABLE OF NUMBER INDEX BY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

3142: AND txn_currency_code = c_txn_currency_code;
3143:
3144: /* Additional types and variables added for Bug 4938603 */
3145: TYPE Char15ToNum
3146: IS TABLE OF NUMBER INDEX BY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3147:
3148: TYPE NumToChar15ToNum
3149: IS TABLE OF Char15ToNum INDEX BY BINARY_INTEGER;
3150:

Line 3154: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

3150:
3151: ra_id_tab NumToChar15ToNum;
3152: new_currency_tab Char15ToNum;
3153: l_ra_id NUMBER;
3154: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3155: n_index NUMBER;
3156: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3157: l_total_plan_qty NUMBER;
3158: l_init_qty NUMBER;

Line 3156: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

3152: new_currency_tab Char15ToNum;
3153: l_ra_id NUMBER;
3154: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3155: n_index NUMBER;
3156: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3157: l_total_plan_qty NUMBER;
3158: l_init_qty NUMBER;
3159:
3160: l_tgt_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;

Line 5190: FROM pa_budget_lines bl,

5186: /* Get indices for budget lines we need to UPDATE */
5187: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5188: tmp.ETC_PLAN_QUANTITY
5189: BULK COLLECT INTO l_upd_index_tab
5190: FROM pa_budget_lines bl,
5191: pa_fp_calc_amt_tmp2 tmp
5192: WHERE bl.budget_version_id = P_TARGET_BV_ID
5193: AND bl.resource_assignment_id = tmp.resource_assignment_id
5194: AND bl.txn_currency_code = tmp.txn_currency_code

Line 5252: INSERT INTO PA_BUDGET_LINES (

5248: END LOOP;
5249:
5250: /* Now that we have insert/update tables populated, do Insert */
5251: FORALL i IN 1..l_ins_tgt_res_asg_id_tab.count
5252: INSERT INTO PA_BUDGET_LINES (
5253: BUDGET_LINE_ID,
5254: BUDGET_VERSION_ID,
5255: RESOURCE_ASSIGNMENT_ID,
5256: START_DATE,

Line 5277: pa_budget_lines_s.nextval,

5273: TXN_COST_RATE_OVERRIDE,
5274: BURDEN_COST_RATE_OVERRIDE,
5275: TXN_BILL_RATE_OVERRIDE)
5276: VALUES (
5277: pa_budget_lines_s.nextval,
5278: P_TARGET_BV_ID,
5279: l_ins_tgt_res_asg_id_tab(i),
5280: l_ins_start_date_tab(i),
5281: l_ins_txn_currency_code_tab(i),

Line 5324: UPDATE PA_BUDGET_LINES

5320: -- instead of l_ins_tgt_res_asg_id_tab.count.
5321:
5322: -- Add Actuals to Plan columns since Calculate API not called in this flow.
5323: FORALL i IN 1..l_upd_tgt_res_asg_id_tab.count
5324: UPDATE PA_BUDGET_LINES
5325: SET TXN_RAW_COST =
5326: DECODE(TXN_INIT_RAW_COST, null, l_upd_txn_raw_cost_tab(i),
5327: TXN_INIT_RAW_COST + NVL(l_upd_txn_raw_cost_tab(i),0)),
5328: TXN_BURDENED_COST =

Line 5361: UPDATE PA_BUDGET_LINES

5357: -- instead of l_ins_tgt_res_asg_id_tab.count.
5358:
5359: -- Set Plan columns to source plan amounts; Calculate API called in this flow.
5360: FORALL i IN 1..l_upd_tgt_res_asg_id_tab.count
5361: UPDATE PA_BUDGET_LINES
5362: SET TXN_RAW_COST = l_upd_txn_raw_cost_tab(i),
5363: TXN_BURDENED_COST = l_upd_txn_brdn_cost_tab(i),
5364: TXN_REVENUE = l_upd_txn_revenue_tab(i),
5365: REVENUE = l_upd_pfc_revenue_tab(i),

Line 5384: INSERT INTO PA_BUDGET_LINES (

5380: END IF; -- Cost-based Revenue check
5381: END IF; -- Update logic
5382: ELSE
5383: FORALL i IN l_tgt_res_asg_id_tab.FIRST..l_tgt_res_asg_id_tab.LAST
5384: INSERT INTO PA_BUDGET_LINES (
5385: BUDGET_LINE_ID,
5386: BUDGET_VERSION_ID,
5387: RESOURCE_ASSIGNMENT_ID,
5388: START_DATE,

Line 5410: pa_budget_lines_s.nextval,

5406: BURDEN_COST_RATE_OVERRIDE,
5407: TXN_BILL_RATE_OVERRIDE,
5408: TXN_MARKUP_PERCENT ) /* Added for Bug 5166047 */
5409: VALUES (
5410: pa_budget_lines_s.nextval,
5411: P_TARGET_BV_ID,
5412: l_tgt_res_asg_id_tab(i),
5413: l_start_date_tab(i),
5414: l_txn_currency_code_tab(i),

Line 5472: pa_budget_lines bl,

5468: rbc.txn_raw_cost_rate_override,
5469: rbc.txn_burden_cost_rate_override,
5470: rbc.txn_bill_rate_override
5471: FROM pa_resource_assignments ra,
5472: pa_budget_lines bl,
5473: pa_resource_asgn_curr rbc,
5474: pa_res_list_map_tmp4 tmp4
5475: WHERE ra.budget_version_id = p_target_bv_id
5476: AND ra.project_id = p_project_id