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 188: pa_budget_lines sbl,

184: NULL,
185: NULL,
186: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
187: FROM pa_res_list_map_tmp4 tmp4,
188: pa_budget_lines sbl,
189: pa_resource_assignments ra,
190: pa_tasks ta /* Added for ER 4376722 */
191: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
192: and sbl.budget_version_id = l_source_id

Line 221: FROM pa_budget_lines

217: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
218: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
219: ) IS
220: SELECT sum(nvl(init_quantity,0))
221: FROM pa_budget_lines
222: WHERE resource_assignment_id = c_res_asgn_id
223: AND txn_currency_code = c_txn_currency_code;
224:
225: l_total_plan_qty NUMBER;

Line 237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;

233: l_calling_context VARCHAR2(30);
234:
235: /* Pro-rate API variables */
236: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

Line 238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;

234:
235: /* Pro-rate API variables */
236: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

Line 239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;

235: /* Pro-rate API variables */
236: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;

Line 240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;

236: l_mapped_src_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
244:

Line 241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;

237: l_prorated_quantity PA_BUDGET_LINES.QUANTITY%TYPE;
238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
244:
245: /* This cursor is the revenue forecast generation analogue of the cursor

Line 242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;

238: l_prorated_txn_raw_cost PA_BUDGET_LINES.TXN_RAW_COST%TYPE;
239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
244:
245: /* This cursor is the revenue forecast generation analogue of the cursor
246: * budget_line_src_to_cal. As such, changes to that cursor should likely be

Line 243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;

239: l_prorated_txn_burdened_cost PA_BUDGET_LINES.TXN_BURDENED_COST%TYPE;
240: l_prorated_txn_revenue PA_BUDGET_LINES.TXN_REVENUE%TYPE;
241: l_prorated_proj_raw_cost PA_BUDGET_LINES.PROJECT_RAW_COST%TYPE;
242: l_prorated_proj_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE;
243: l_prorated_proj_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE;
244:
245: /* This cursor is the revenue forecast generation analogue of the cursor
246: * budget_line_src_to_cal. As such, changes to that cursor should likely be
247: * mirorred here. See comments above the other cursor for more info.

Line 288: pa_budget_lines sbl,

284: NULL,
285: NULL,
286: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
287: FROM pa_res_list_map_tmp4 tmp4,
288: pa_budget_lines sbl,
289: pa_resource_assignments ra,
290: pa_tasks ta /* Added for ER 4376722 */
291: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
292: and sbl.budget_version_id = l_source_id

Line 359: pa_budget_lines sbl,

355: NULL,
356: NULL,
357: NVL(ta.billable_flag,'Y') /* Added for ER 4376722 */
358: FROM pa_res_list_map_tmp4 tmp4,
359: pa_budget_lines sbl,
360: pa_resource_assignments ra,
361: pa_tasks ta /* Added for ER 4376722 */
362: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
363: and sbl.budget_version_id = l_source_id

Line 1365: DELETE FROM pa_budget_lines bl

1361: * must Delete (non-actuals) budget lines for resources that are not
1362: * manually added/edited. */
1363: IF p_retain_manual_flag = 'Y' THEN
1364: IF l_calling_context = lc_BudgetGeneration THEN
1365: DELETE FROM pa_budget_lines bl
1366: WHERE budget_version_id = p_budget_version_id
1367: AND EXISTS
1368: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1369: FROM pa_res_list_map_tmp4 tmp

Line 1376: DELETE FROM pa_budget_lines bl

1372: ELSIF l_calling_context = lc_ForecastGeneration THEN
1373: l_etc_start_date := PA_FP_GEN_AMOUNT_UTILS.GET_ETC_START_DATE
1374: ( p_budget_version_id );
1375: IF l_fp_cols_rec_target.x_time_phased_code IN ('P','G') THEN
1376: DELETE FROM pa_budget_lines bl
1377: WHERE budget_version_id = p_budget_version_id
1378: AND EXISTS
1379: ( SELECT /*+ INDEX(tmp,PA_RES_LIST_MAP_TMP4_N2)*/ 1
1380: FROM pa_res_list_map_tmp4 tmp

Line 1389: *unique identifiers for pa_budget_lines:

1385: END IF;
1386: END IF; -- end budget line deletion
1387:
1388: /**Populating target budget lines by summing up the values.
1389: *unique identifiers for pa_budget_lines:
1390: *1.resource_assignment_id : corresponds to one budget_version_id;
1391: *=one planning element; rlmID from pa_resource_assignment
1392: *2.currency
1393: *3.start_date**/

Line 1501: FROM pa_Budget_lines bl,

1497: l_src_revenue_tab,
1498: l_cost_rate_override_tab,
1499: l_b_cost_rate_override_tab,
1500: l_bill_rate_override_tab
1501: FROM pa_Budget_lines bl,
1502: pa_resource_assignments ra
1503: WHERE bl.budget_version_id = p_budget_version_id
1504: AND ra.budget_version_id = p_budget_version_id
1505: AND bl.resource_assignment_id = ra.resource_assignment_id

Line 2630: pa_budget_lines where

2626: FOR k IN 1 .. l_tgt_res_asg_id_tab.COUNT LOOP
2627: BEGIN
2628: SELECT sum(init_quantity),sum(init_revenue) into
2629: l_calc_qty_tmp, l_calc_tmp_rev FROM
2630: pa_budget_lines where
2631: resource_assignment_id = l_tgt_res_asg_id_tab(k) AND
2632: txn_currency_code = l_txn_currency_code_tab(k);
2633: EXCEPTION
2634: WHEN NO_DATA_FOUND THEN

Line 2898: pa_budget_lines sbl,

2894: NULL,
2895: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
2896: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
2897: FROM pa_res_list_map_tmp4 tmp4,
2898: pa_budget_lines sbl,
2899: pa_resource_assignments ra,
2900: pa_tasks ta /* Added for ER 4376722 */
2901: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2902: and sbl.budget_version_id = p_source_bv_id

Line 2988: pa_budget_lines sbl,

2984: NULL,
2985: NVL(ta.billable_flag,'Y'),
2986: avg(sbl.txn_markup_percent) -- Bug #13552225
2987: FROM pa_res_list_map_tmp4 tmp4,
2988: pa_budget_lines sbl,
2989: pa_resource_assignments ra,
2990: pa_tasks ta
2991: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
2992: and sbl.budget_version_id = p_source_bv_id

Line 3084: pa_budget_lines sbl,

3080: NULL,
3081: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3082: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3083: FROM pa_res_list_map_tmp4 tmp4,
3084: pa_budget_lines sbl,
3085: pa_resource_assignments ra,
3086: pa_tasks ta /* Added for ER 4376722 */
3087: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3088: and sbl.budget_version_id = p_source_bv_id

Line 3181: pa_budget_lines sbl,

3177: NULL,
3178: NVL(ta.billable_flag,'Y'), /* Added for ER 4376722 */
3179: avg(sbl.txn_markup_percent) /* Added for Bug 5166047 */
3180: FROM pa_res_list_map_tmp4 tmp4,
3181: pa_budget_lines sbl,
3182: pa_resource_assignments ra,
3183: pa_tasks ta /* Added for ER 4376722 */
3184: WHERE tmp4.txn_source_id = sbl.resource_assignment_id
3185: and sbl.budget_version_id = p_source_bv_id

Line 3218: FROM pa_budget_lines

3214: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3215: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3216: ) IS
3217: SELECT sum(nvl(init_quantity,0))
3218: FROM pa_budget_lines
3219: WHERE resource_assignment_id = c_res_asgn_id
3220: AND txn_currency_code = c_txn_currency_code;
3221:
3222: /* Additional types and variables added for Bug 4938603 */

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

3220: AND txn_currency_code = c_txn_currency_code;
3221:
3222: /* Additional types and variables added for Bug 4938603 */
3223: TYPE Char15ToNum
3224: IS TABLE OF NUMBER INDEX BY PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3225:
3226: TYPE NumToChar15ToNum
3227: IS TABLE OF Char15ToNum INDEX BY BINARY_INTEGER;
3228:

Line 3232: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

3228:
3229: ra_id_tab NumToChar15ToNum;
3230: new_currency_tab Char15ToNum;
3231: l_ra_id NUMBER;
3232: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3233: n_index NUMBER;
3234: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3235: l_total_plan_qty NUMBER;
3236: l_init_qty NUMBER;

Line 3234: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

3230: new_currency_tab Char15ToNum;
3231: l_ra_id NUMBER;
3232: l_currency PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3233: n_index NUMBER;
3234: s_index PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
3235: l_total_plan_qty NUMBER;
3236: l_init_qty NUMBER;
3237:
3238: l_tgt_res_asg_id_tab pa_plsql_datatypes.IdTabTyp;

Line 5269: FROM pa_budget_lines bl,

5265: /* Get indices for budget lines we need to UPDATE */
5266: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP2_N2)*/
5267: tmp.ETC_PLAN_QUANTITY
5268: BULK COLLECT INTO l_upd_index_tab
5269: FROM pa_budget_lines bl,
5270: pa_fp_calc_amt_tmp2 tmp
5271: WHERE bl.budget_version_id = P_TARGET_BV_ID
5272: AND bl.resource_assignment_id = tmp.resource_assignment_id
5273: AND bl.txn_currency_code = tmp.txn_currency_code

Line 5331: INSERT INTO PA_BUDGET_LINES (

5327: END LOOP;
5328:
5329: /* Now that we have insert/update tables populated, do Insert */
5330: FORALL i IN 1..l_ins_tgt_res_asg_id_tab.count
5331: INSERT INTO PA_BUDGET_LINES (
5332: BUDGET_LINE_ID,
5333: BUDGET_VERSION_ID,
5334: RESOURCE_ASSIGNMENT_ID,
5335: START_DATE,

Line 5356: pa_budget_lines_s.nextval,

5352: TXN_COST_RATE_OVERRIDE,
5353: BURDEN_COST_RATE_OVERRIDE,
5354: TXN_BILL_RATE_OVERRIDE)
5355: VALUES (
5356: pa_budget_lines_s.nextval,
5357: P_TARGET_BV_ID,
5358: l_ins_tgt_res_asg_id_tab(i),
5359: l_ins_start_date_tab(i),
5360: l_ins_txn_currency_code_tab(i),

Line 5403: UPDATE PA_BUDGET_LINES

5399: -- instead of l_ins_tgt_res_asg_id_tab.count.
5400:
5401: -- Add Actuals to Plan columns since Calculate API not called in this flow.
5402: FORALL i IN 1..l_upd_tgt_res_asg_id_tab.count
5403: UPDATE PA_BUDGET_LINES
5404: SET TXN_RAW_COST =
5405: DECODE(TXN_INIT_RAW_COST, null, l_upd_txn_raw_cost_tab(i),
5406: TXN_INIT_RAW_COST + NVL(l_upd_txn_raw_cost_tab(i),0)),
5407: TXN_BURDENED_COST =

Line 5440: UPDATE PA_BUDGET_LINES

5436: -- instead of l_ins_tgt_res_asg_id_tab.count.
5437:
5438: -- Set Plan columns to source plan amounts; Calculate API called in this flow.
5439: FORALL i IN 1..l_upd_tgt_res_asg_id_tab.count
5440: UPDATE PA_BUDGET_LINES
5441: SET TXN_RAW_COST = l_upd_txn_raw_cost_tab(i),
5442: TXN_BURDENED_COST = l_upd_txn_brdn_cost_tab(i),
5443: TXN_REVENUE = l_upd_txn_revenue_tab(i),
5444: REVENUE = l_upd_pfc_revenue_tab(i),

Line 5463: INSERT INTO PA_BUDGET_LINES (

5459: END IF; -- Cost-based Revenue check
5460: END IF; -- Update logic
5461: ELSE
5462: FORALL i IN l_tgt_res_asg_id_tab.FIRST..l_tgt_res_asg_id_tab.LAST
5463: INSERT INTO PA_BUDGET_LINES (
5464: BUDGET_LINE_ID,
5465: BUDGET_VERSION_ID,
5466: RESOURCE_ASSIGNMENT_ID,
5467: START_DATE,

Line 5489: pa_budget_lines_s.nextval,

5485: BURDEN_COST_RATE_OVERRIDE,
5486: TXN_BILL_RATE_OVERRIDE,
5487: TXN_MARKUP_PERCENT ) /* Added for Bug 5166047 */
5488: VALUES (
5489: pa_budget_lines_s.nextval,
5490: P_TARGET_BV_ID,
5491: l_tgt_res_asg_id_tab(i),
5492: l_start_date_tab(i),
5493: l_txn_currency_code_tab(i),

Line 5551: pa_budget_lines bl,

5547: rbc.txn_raw_cost_rate_override,
5548: rbc.txn_burden_cost_rate_override,
5549: rbc.txn_bill_rate_override
5550: FROM pa_resource_assignments ra,
5551: pa_budget_lines bl,
5552: pa_resource_asgn_curr rbc,
5553: pa_res_list_map_tmp4 tmp4
5554: WHERE ra.budget_version_id = p_target_bv_id
5555: AND ra.project_id = p_project_id