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

Line 7: Populate init columns in PA_BUDGET_LINES.

3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /**MAINTAIN_ACTUAL_AMT_WRP will get value from PA_PROG_ACT_BY_PERIOD_TEMP view*
7: *Populate init columns in PA_BUDGET_LINES. *
8: *Valid values for parameter P_CALLING_CONTEXT are:*
9: * WP_PROGRESS -- Work plan progress *
10: * WP_SUMMARIZED_ACTUAL -- Work plan summarized actual transactions *
11: * WP_APPLY_PROGRESS_TO_WORKING *

Line 203: UPDATE pa_budget_lines

199: -- Calling context = 'WP_SUMMARIZED_ACTUAL' and extraction_type = 'FULL'
200:
201: IF (P_EXTRACTION_TYPE = 'FULL' AND
202: P_CALLING_CONTEXT = 'WP_SUMMARIZED_ACTUAL') THEN
203: UPDATE pa_budget_lines
204: SET TXN_INIT_RAW_COST = decode(TXN_INIT_RAW_COST,null,null,0),
205: TXN_INIT_BURDENED_COST = decode(TXN_INIT_BURDENED_COST,null,null,0),
206: ---TXN_INIT_REVENUE = decode(TXN_INIT_REVENUE,null,null,0),
207: PROJECT_INIT_RAW_COST = decode(PROJECT_INIT_RAW_COST,null,null,0),

Line 499: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||

495: -- Populate the display quantity for processed workplan resources
496:
497: IF p_pa_debug_mode = 'Y' THEN
498: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
499: P_MSG => 'Before calling PA_BUDGET_LINES_UTILS.' ||
500: 'POPULATE_DISPLAY_QTY',
501: --P_CALLED_MODE => p_called_mode,
502: P_MODULE_NAME => l_module_name);
503: END IF;

Line 504: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY

500: 'POPULATE_DISPLAY_QTY',
501: --P_CALLED_MODE => p_called_mode,
502: P_MODULE_NAME => l_module_name);
503: END IF;
504: PA_BUDGET_LINES_UTILS.POPULATE_DISPLAY_QTY
505: ( P_BUDGET_VERSION_ID => l_bv_id,
506: P_CONTEXT => 'WORKPLAN',
507: p_resource_assignment_id_tab => l_display_qty_ra_id_tab,
508: X_RETURN_STATUS => x_return_status );

Line 511: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||

507: p_resource_assignment_id_tab => l_display_qty_ra_id_tab,
508: X_RETURN_STATUS => x_return_status );
509: IF p_pa_debug_mode = 'Y' THEN
510: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
511: P_MSG => 'After calling PA_BUDGET_LINES_UTILS.' ||
512: 'POPULATE_DISPLAY_QTY: '||x_return_status,
513: --P_CALLED_MODE => p_called_mode,
514: P_MODULE_NAME => l_module_name);
515: END IF;

Line 862: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,

858: PROCEDURE MAINTAIN_ACTUAL_AMT_RA
859: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,
860: P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
861: P_RESOURCE_ASSIGNMENT_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
862: P_TXN_CURRENCY_CODE IN PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE,
863: P_AMT_DTLS_REC_TAB IN PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ,
864: P_CALLING_CONTEXT IN VARCHAR2,
865: P_TXN_AMT_TYPE_CODE IN VARCHAR2,
866: P_CALLING_MODE IN VARCHAR2,

Line 938: l_bdgt_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

934: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
935: l_last_update_login NUMBER := FND_GLOBAL.login_id;
936: l_sysdate DATE := SYSDATE;
937:
938: l_bdgt_line_id PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
939: l_bdgt_line_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
940:
941: l_upd_ind NUMBER := 1;
942: l_ins_ind NUMBER := 1;

Line 1135: FROM pa_budget_lines

1131:
1132: BEGIN
1133: SELECT 'N'
1134: INTO l_ins_flag
1135: FROM pa_budget_lines
1136: WHERE resource_assignment_id = p_resource_assignment_id
1137: AND txn_currency_code = p_txn_currency_code
1138: AND rownum < 2;
1139: EXCEPTION

Line 1152: /* Bulk Insert in PA_BUDGET_LINES table */

1148: p_module_name => l_module_name,
1149: p_log_level => 5);
1150: END IF;
1151:
1152: /* Bulk Insert in PA_BUDGET_LINES table */
1153:
1154: -- Bug 4071198: When p_txn_amt_type_code = ACTUAL_TXN (i.e. the
1155: -- context is FP_GEN_FCST_COPY_ACTUAL ), we populate the appropriate
1156: -- override rates in the budget lines. Code changes are tagged with bug# 4071198

Line 1185: PA_BUDGET_LINES(BUDGET_VERSION_ID,

1181:
1182: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1183: FORALL j in 1..l_period_name_tab.count
1184: INSERT INTO
1185: PA_BUDGET_LINES(BUDGET_VERSION_ID,
1186: RESOURCE_ASSIGNMENT_ID,
1187: PERIOD_NAME,
1188: START_DATE,
1189: END_DATE,

Line 1246: PA_BUDGET_LINES_S.nextval,

1242: l_project_revenue_tab(j),
1243: l_pfc_raw_cost_tab(j),
1244: l_pfc_burdened_cost_tab(j),
1245: l_pfc_revenue_tab(j),
1246: PA_BUDGET_LINES_S.nextval,
1247: l_sysdate,
1248: l_last_updated_by,
1249: l_sysdate,
1250: l_last_updated_by,

Line 1263: PA_BUDGET_LINES(BUDGET_VERSION_ID,

1259: RETURNING budget_line_id BULK COLLECT INTO l_bl_id_tab;
1260: ELSE -- 'WP_APPLY_PROGRESS_TO_WORKING'
1261: FORALL j in 1..l_period_name_tab.count
1262: INSERT INTO
1263: PA_BUDGET_LINES(BUDGET_VERSION_ID,
1264: RESOURCE_ASSIGNMENT_ID,
1265: PERIOD_NAME,
1266: START_DATE,
1267: END_DATE,

Line 1324: PA_BUDGET_LINES_S.nextval,

1320: l_project_revenue_tab(j),
1321: l_pfc_raw_cost_tab(j),
1322: l_pfc_burdened_cost_tab(j),
1323: l_pfc_revenue_tab(j),
1324: PA_BUDGET_LINES_S.nextval,
1325: l_sysdate,
1326: l_last_updated_by,
1327: l_sysdate,
1328: l_last_updated_by,

Line 1364: PA_BUDGET_LINES(BUDGET_VERSION_ID,

1360:
1361: l_bl_id_tab.delete;
1362: FORALL j in 1..l_period_name_tab.count
1363: INSERT INTO
1364: PA_BUDGET_LINES(BUDGET_VERSION_ID,
1365: RESOURCE_ASSIGNMENT_ID,
1366: PERIOD_NAME,
1367: START_DATE,
1368: END_DATE,

Line 1403: PA_BUDGET_LINES_S.nextval,

1399: l_project_revenue_tab(j),
1400: l_pfc_raw_cost_tab(j),
1401: l_pfc_burdened_cost_tab(j),
1402: l_pfc_revenue_tab(j),
1403: PA_BUDGET_LINES_S.nextval,
1404: l_sysdate,
1405: l_last_updated_by,
1406: l_sysdate,
1407: l_last_updated_by,

Line 1425: PA_BUDGET_LINES(BUDGET_VERSION_ID,

1421: END IF;
1422: l_bl_id_tab.delete;
1423: FORALL j2 in 1..l_period_name_tab.count
1424: INSERT INTO
1425: PA_BUDGET_LINES(BUDGET_VERSION_ID,
1426: RESOURCE_ASSIGNMENT_ID,
1427: PERIOD_NAME,
1428: START_DATE,
1429: END_DATE,

Line 1471: PA_BUDGET_LINES_S.nextval,

1467: l_project_revenue_tab(j2),
1468: l_pfc_raw_cost_tab(j2),
1469: l_pfc_burdened_cost_tab(j2),
1470: l_pfc_revenue_tab(j2),
1471: PA_BUDGET_LINES_S.nextval,
1472: l_sysdate,
1473: l_last_updated_by,
1474: l_sysdate,
1475: l_last_updated_by,

Line 1552: FROM pa_budget_lines

1548: l_quantity,
1549: l_txn_cost_rate_override,
1550: l_burden_cost_rate_override,
1551: l_txn_bill_rate_override
1552: FROM pa_budget_lines
1553: WHERE resource_assignment_id = p_resource_assignment_id
1554: AND start_date = l_start_date_tab(k)
1555: AND txn_currency_code = p_txn_currency_code;
1556: ELSE

Line 1559: FROM pa_budget_lines

1555: AND txn_currency_code = p_txn_currency_code;
1556: ELSE
1557: SELECT budget_line_id
1558: INTO l_bdgt_line_id
1559: FROM pa_budget_lines
1560: WHERE resource_assignment_id = p_resource_assignment_id
1561: AND start_date = l_start_date_tab(k)
1562: AND txn_currency_code = p_txn_currency_code;
1563: END IF;

Line 1567: FROM pa_budget_lines

1563: END IF;
1564: ELSIF l_time_phased_code = 'N' THEN
1565: SELECT budget_line_id
1566: INTO l_bdgt_line_id
1567: FROM pa_budget_lines
1568: WHERE resource_assignment_id = p_resource_assignment_id
1569: AND txn_currency_code = p_txn_currency_code;
1570: END IF;
1571:

Line 1680: /* Bulk Update in PA_BUDGET_LINES table */

1676:
1677: /* dbms_output.put_line('Update count when the ins_flag is null:
1678: '|| l_upd_period_name_tab.count);*/
1679:
1680: /* Bulk Update in PA_BUDGET_LINES table */
1681: IF l_upd_period_name_tab.count > 0 THEN
1682: IF (p_txn_amt_type_code = 'ACTUAL_TXN' AND
1683: (p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING'
1684: OR p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL')) THEN

Line 1689: UPDATE pa_budget_lines

1685:
1686: IF p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING'
1687: AND P_EXTRACTION_TYPE = 'INCREMENTAL' THEN
1688: FORALL m in 1..l_upd_period_name_tab.count
1689: UPDATE pa_budget_lines
1690: SET
1691: TXN_INIT_RAW_COST = NVL(TXN_INIT_RAW_COST,0) + l_upd_txn_raw_cost_tab(m),
1692: TXN_INIT_BURDENED_COST = NVL(TXN_INIT_BURDENED_COST,0) + l_upd_txn_burdened_cost_tab(m),
1693: TXN_INIT_REVENUE = NVL(TXN_INIT_REVENUE,0) + l_upd_txn_revenue_tab(m),

Line 1726: UPDATE pa_budget_lines SET

1722: /* bug 4398799 start */
1723: IF l_version_type = 'COST' THEN
1724:
1725: FORALL m in 1..l_upd_period_name_tab.count
1726: UPDATE pa_budget_lines SET
1727: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1728: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity)
1729: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1730:

Line 1734: UPDATE pa_budget_lines SET

1730:
1731: ELSIF l_version_type = 'REVENUE' THEN
1732:
1733: FORALL m in 1..l_upd_period_name_tab.count
1734: UPDATE pa_budget_lines SET
1735: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1736: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1737:
1738: ELSIF l_version_type = 'ALL' THEN

Line 1741: UPDATE pa_budget_lines SET

1737:
1738: ELSIF l_version_type = 'ALL' THEN
1739:
1740: FORALL m in 1..l_upd_period_name_tab.count
1741: UPDATE pa_budget_lines SET
1742: TXN_STANDARD_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_raw_cost / quantity),
1743: BURDEN_COST_RATE = decode (nvl(quantity,0), 0, NULL, txn_burdened_cost/quantity),
1744: TXN_STANDARD_BILL_RATE = decode (nvl(quantity,0), 0, NULL, txn_revenue/quantity)
1745: WHERE budget_line_id = l_bdgt_line_id_tab(m);

Line 1759: UPDATE pa_budget_lines

1755: ELSIF l_open_pd_plan_amt_flag = 'Y' AND
1756: p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING' AND
1757: P_EXTRACTION_TYPE = 'FULL' THEN
1758: FORALL m in 1..l_upd_period_name_tab.count
1759: UPDATE pa_budget_lines
1760: SET
1761: TXN_INIT_RAW_COST = l_upd_txn_raw_cost_tab(m),
1762: TXN_INIT_BURDENED_COST = l_upd_txn_burdened_cost_tab(m),
1763: TXN_INIT_REVENUE = l_upd_txn_revenue_tab(m),

Line 1819: UPDATE pa_budget_lines

1815: -- Workplan behavior.
1816:
1817: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1818: FORALL m in 1..l_upd_period_name_tab.count
1819: UPDATE pa_budget_lines
1820: SET -- Begin 4376722, 4292083 changes --
1821: TXN_RAW_COST =
1822: DECODE(TXN_RAW_COST, null, l_upd_txn_raw_cost_tab(m),
1823: TXN_RAW_COST + NVL(l_upd_txn_raw_cost_tab(m),0)),

Line 1870: UPDATE pa_budget_lines

1866: INIT_QUANTITY = l_upd_qty_tab(m)
1867: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1868: ELSE -- 'WP_APPLY_PROGRESS_TO_WORKING'
1869: FORALL m in 1..l_upd_period_name_tab.count
1870: UPDATE pa_budget_lines
1871: SET -- Begin 4292083 changes --
1872: TXN_RAW_COST = NVL(TXN_RAW_COST,0)
1873: + l_upd_txn_raw_cost_tab(m),
1874: TXN_BURDENED_COST = NVL(TXN_BURDENED_COST,0)

Line 1921: UPDATE pa_budget_lines

1917: -- the UPDATE statements is unchanged.
1918:
1919: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
1920: FORALL m in 1..l_upd_period_name_tab.count
1921: UPDATE pa_budget_lines
1922: SET
1923: TXN_INIT_RAW_COST = l_upd_txn_raw_cost_tab(m),
1924: TXN_INIT_BURDENED_COST = l_upd_txn_burdened_cost_tab(m),
1925: TXN_INIT_REVENUE = l_upd_txn_revenue_tab(m),

Line 1954: UPDATE pa_budget_lines

1950: TXN_BILL_RATE_OVERRIDE = l_upd_bill_rate_override_tab(m) /* Bug 4071198 end */
1951: WHERE budget_line_id = l_bdgt_line_id_tab(m);
1952: ELSE -- 'WP_APPLY_PROGRESS_TO_WORKING'
1953: FORALL m in 1..l_upd_period_name_tab.count
1954: UPDATE pa_budget_lines
1955: SET
1956: TXN_INIT_RAW_COST = l_upd_txn_raw_cost_tab(m),
1957: TXN_INIT_BURDENED_COST = l_upd_txn_burdened_cost_tab(m),
1958: TXN_INIT_REVENUE = l_upd_txn_revenue_tab(m),

Line 1995: UPDATE pa_budget_lines

1991: p_calling_context = 'WP_SUMMARIZED_ACTUAL') THEN
1992:
1993: IF P_EXTRACTION_TYPE = 'INCREMENTAL' THEN
1994: FORALL m in 1..l_upd_period_name_tab.count
1995: UPDATE pa_budget_lines
1996: SET
1997: TXN_INIT_RAW_COST = NVL(TXN_INIT_RAW_COST,0) + l_upd_txn_raw_cost_tab(m),
1998: TXN_INIT_BURDENED_COST = NVL(TXN_INIT_BURDENED_COST,0) + l_upd_txn_burdened_cost_tab(m),
1999: TXN_INIT_REVENUE = NVL(TXN_INIT_REVENUE,0) + l_upd_txn_revenue_tab(m),

Line 2015: UPDATE pa_budget_lines

2011: INIT_QUANTITY = NVL(INIT_QUANTITY,0) + l_upd_qty_tab(m)
2012: WHERE budget_line_id = l_bdgt_line_id_tab(m);
2013: ELSE
2014: FORALL m in 1..l_upd_period_name_tab.count
2015: UPDATE pa_budget_lines
2016: SET
2017: TXN_INIT_RAW_COST = l_upd_txn_raw_cost_tab(m),
2018: TXN_INIT_BURDENED_COST = l_upd_txn_burdened_cost_tab(m),
2019: TXN_INIT_REVENUE = l_upd_txn_revenue_tab(m),

Line 2061: UPDATE pa_budget_lines

2057: -- Using the new logic, we would set revenue to actual revenue +
2058: -- NVL(NULL,0) = actual revenue.
2059:
2060: FORALL m2 in 1..l_upd_period_name_tab.count
2061: UPDATE pa_budget_lines
2062: SET
2063: TXN_RAW_COST =
2064: DECODE(TXN_INIT_RAW_COST, null, l_upd_txn_raw_cost_tab(m2),
2065: TXN_INIT_RAW_COST + NVL(l_upd_txn_raw_cost_tab(m2),0)),

Line 2108: UPDATE pa_budget_lines

2104: TXN_BILL_RATE_OVERRIDE = l_upd_bill_rate_override_tab(m2)
2105: WHERE budget_line_id = l_bdgt_line_id_tab(m2);
2106: ELSE
2107: FORALL m2 in 1..l_upd_period_name_tab.count
2108: UPDATE pa_budget_lines
2109: SET
2110: TXN_RAW_COST = l_upd_txn_raw_cost_tab(m2),
2111: TXN_BURDENED_COST = l_upd_txn_burdened_cost_tab(m2),
2112: TXN_REVENUE = l_upd_txn_revenue_tab(m2),

Line 2140: --Bulk Insert in PA_BUDGET_LINES table

2136: END IF;
2137:
2138: /* dbms_output.put_line('Insert count when the ins_flag is null:
2139: '|| l_ins_period_name_tab.count);*/
2140: --Bulk Insert in PA_BUDGET_LINES table
2141:
2142: IF l_ins_period_name_tab.count > 0 THEN
2143: IF (p_txn_amt_type_code = 'ACTUAL_TXN' AND
2144: (p_calling_context = 'WP_APPLY_PROGRESS_TO_WORKING'

Line 2159: PA_BUDGET_LINES(BUDGET_VERSION_ID,

2155:
2156: IF p_calling_context = 'FP_GEN_FCST_COPY_ACTUAL' THEN
2157: FORALL n in 1..l_ins_period_name_tab.count
2158: INSERT INTO
2159: PA_BUDGET_LINES(BUDGET_VERSION_ID,
2160: RESOURCE_ASSIGNMENT_ID,
2161: PERIOD_NAME,
2162: START_DATE,
2163: END_DATE,

Line 2220: PA_BUDGET_LINES_S.nextval,

2216: l_ins_project_revenue_tab(n),
2217: l_ins_pfc_raw_cost_tab(n),
2218: l_ins_pfc_burdened_cost_tab(n),
2219: l_ins_pfc_revenue_tab(n),
2220: PA_BUDGET_LINES_S.nextval,
2221: l_sysdate,
2222: l_last_updated_by,
2223: l_sysdate,
2224: l_last_updated_by,

Line 2238: PA_BUDGET_LINES(BUDGET_VERSION_ID,

2234: BULK COLLECT INTO l_bl_id_tab;
2235: ELSE -- 'WP_APPLY_PROGRESS_TO_WORKING'
2236: FORALL n in 1..l_ins_period_name_tab.count
2237: INSERT INTO
2238: PA_BUDGET_LINES(BUDGET_VERSION_ID,
2239: RESOURCE_ASSIGNMENT_ID,
2240: PERIOD_NAME,
2241: START_DATE,
2242: END_DATE,

Line 2299: PA_BUDGET_LINES_S.nextval,

2295: l_ins_project_revenue_tab(n),
2296: l_ins_pfc_raw_cost_tab(n),
2297: l_ins_pfc_burdened_cost_tab(n),
2298: l_ins_pfc_revenue_tab(n),
2299: PA_BUDGET_LINES_S.nextval,
2300: l_sysdate,
2301: l_last_updated_by,
2302: l_sysdate,
2303: l_last_updated_by,

Line 2321: PA_BUDGET_LINES(BUDGET_VERSION_ID,

2317: p_calling_context = 'WP_SUMMARIZED_ACTUAL') THEN
2318: l_bl_id_tab.delete;
2319: FORALL n in 1..l_ins_period_name_tab.count
2320: INSERT INTO
2321: PA_BUDGET_LINES(BUDGET_VERSION_ID,
2322: RESOURCE_ASSIGNMENT_ID,
2323: PERIOD_NAME,
2324: START_DATE,
2325: END_DATE,

Line 2360: PA_BUDGET_LINES_S.nextval,

2356: l_ins_project_revenue_tab(n),
2357: l_ins_pfc_raw_cost_tab(n),
2358: l_ins_pfc_burdened_cost_tab(n),
2359: l_ins_pfc_revenue_tab(n),
2360: PA_BUDGET_LINES_S.nextval,
2361: l_sysdate,
2362: l_last_updated_by,
2363: l_sysdate,
2364: l_last_updated_by,

Line 2373: PA_BUDGET_LINES(BUDGET_VERSION_ID,

2369: ELSIF p_txn_amt_type_code = 'PLANNING_TXN' THEN
2370: l_bl_id_tab.delete;
2371: FORALL n2 in 1..l_ins_period_name_tab.count
2372: INSERT INTO
2373: PA_BUDGET_LINES(BUDGET_VERSION_ID,
2374: RESOURCE_ASSIGNMENT_ID,
2375: PERIOD_NAME,
2376: START_DATE,
2377: END_DATE,

Line 2419: PA_BUDGET_LINES_S.nextval,

2415: l_ins_project_revenue_tab(n2),
2416: l_ins_pfc_raw_cost_tab(n2),
2417: l_ins_pfc_burdened_cost_tab(n2),
2418: l_ins_pfc_revenue_tab(n2),
2419: PA_BUDGET_LINES_S.nextval,
2420: l_sysdate,
2421: l_last_updated_by,
2422: l_sysdate,
2423: l_last_updated_by,

Line 2472: FROM pa_budget_lines

2468: IF l_spread_curve_code = 'FIXED_DATE' THEN
2469: --Getting the number of budget lines for the given res_asg_id and txn_curr_code
2470: SELECT count(*)
2471: INTO l_multi_bdgt_lines
2472: FROM pa_budget_lines
2473: WHERE resource_assignment_id = p_resource_assignment_id
2474: AND txn_currency_code = p_txn_currency_code;
2475:
2476: --Need to update res asg table if there are multiple budget lines

Line 2578: pa_budget_lines bl,

2574: min(bl.start_date),
2575: max(bl.end_date)
2576: FROM pa_resource_assignments ra,
2577: pa_budget_versions bv, -- Added for Perf Bug 4469690
2578: pa_budget_lines bl,
2579: pa_periods_all start_pd,
2580: pa_periods_all end_pd
2581: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2582: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2605: pa_budget_lines bl,

2601: min(bl.start_date),
2602: max(bl.end_date)
2603: FROM pa_resource_assignments ra,
2604: pa_budget_versions bv, -- Added for Perf Bug 4469690
2605: pa_budget_lines bl,
2606: gl_period_statuses start_pd,
2607: gl_period_statuses end_pd
2608: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2609: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690

Line 2636: pa_budget_lines bl

2632: min(bl.start_date),
2633: max(bl.end_date)
2634: FROM pa_resource_assignments ra,
2635: pa_budget_versions bv, -- Added for Perf Bug 4469690
2636: pa_budget_lines bl
2637: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2638: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2639: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690
2640: AND bv.budget_version_id = p_budget_version_id -- Added for Perf Bug 4469690

Line 2678: pa_budget_lines bl,

2674: min(bl.start_date),
2675: max(bl.end_date)
2676: FROM pa_resource_assignments ra,
2677: pa_budget_versions bv, -- Added for Perf Bug 4469690
2678: pa_budget_lines bl,
2679: pji_fm_xbs_accum_tmp1 pji_tmp,
2680: pa_periods_all start_pd,
2681: pa_periods_all end_pd
2682: WHERE ra.resource_assignment_id = bl.resource_assignment_id

Line 2707: pa_budget_lines bl,

2703: min(bl.start_date),
2704: max(bl.end_date)
2705: FROM pa_resource_assignments ra,
2706: pa_budget_versions bv, -- Added for Perf Bug 4469690
2707: pa_budget_lines bl,
2708: pji_fm_xbs_accum_tmp1 pji_tmp,
2709: gl_period_statuses start_pd,
2710: gl_period_statuses end_pd
2711: WHERE ra.resource_assignment_id = bl.resource_assignment_id

Line 2740: pa_budget_lines bl,

2736: min(bl.start_date),
2737: max(bl.end_date)
2738: FROM pa_resource_assignments ra,
2739: pa_budget_versions bv, -- Added for Perf Bug 4469690
2740: pa_budget_lines bl,
2741: pji_fm_xbs_accum_tmp1 pji_tmp
2742: WHERE ra.resource_assignment_id = bl.resource_assignment_id
2743: AND ra.budget_version_id = bv.budget_version_id -- Added for Perf Bug 4469690
2744: AND ra.project_id = bv.project_id -- Added for Perf Bug 4469690

Line 3087: UPDATE pa_budget_lines

3083:
3084: IF l_fp_cols_rec.x_time_phased_code = 'N' AND
3085: l_wp_version_flag = 'Y' THEN
3086: FORALL m IN 1..l_upd_res_asg_id_tab.count
3087: UPDATE pa_budget_lines
3088: SET start_date = l_upd_start_date_tab(m),
3089: end_date = l_upd_end_date_tab(m)
3090: WHERE resource_assignment_id = l_upd_res_asg_id_tab(m);
3091: END IF;

Line 3317: FROM pa_budget_lines

3313: ,l_rep_prj_act_rev_tab
3314: ,l_rep_pf_act_raw_cost_tab
3315: ,l_rep_pf_act_burd_cost_tab
3316: ,l_rep_pf_act_rev_tab
3317: FROM pa_budget_lines
3318: WHERE budget_version_id = P_BUDGET_VERSION_ID;
3319: ELSE
3320: DELETE FROM pa_fp_calc_amt_tmp1;
3321: FORALL i IN 1..p_res_asg_id_tab.count

Line 3423: FROM pa_budget_lines bl, pa_fp_calc_amt_tmp1 tmp

3419: ,l_rep_prj_act_rev_tab
3420: ,l_rep_pf_act_raw_cost_tab
3421: ,l_rep_pf_act_burd_cost_tab
3422: ,l_rep_pf_act_rev_tab
3423: FROM pa_budget_lines bl, pa_fp_calc_amt_tmp1 tmp
3424: WHERE bl.budget_version_id = P_BUDGET_VERSION_ID
3425: AND bl.resource_assignment_id = tmp.resource_assignment_id;
3426: END IF;
3427:

Line 3609: FROM pa_budget_lines

3605: FOR i IN 1..l_res_asg_id_tab.count LOOP
3606: SELECT budget_line_id
3607: BULK COLLECT INTO
3608: l_budget_line_id_tab
3609: FROM pa_budget_lines
3610: WHERE resource_assignment_id = l_res_asg_id_tab(i);
3611:
3612: IF l_budget_line_id_tab.count = 0 THEN
3613: l_dummy := 0;

Line 3623: FROM pa_budget_lines

3619: INTO l_min_start_date,
3620: l_max_end_date,
3621: l_sum_init_quantity,
3622: l_sum_plan_quantity
3623: FROM pa_budget_lines
3624: WHERE resource_assignment_id = l_res_asg_id_tab(i);
3625:
3626: -- Bug 4217917: If the Context is Forecast Generation and a resource
3627: -- has ETC but the Planning End Date falls prior to the ETC Start Date,

Line 3640: UPDATE pa_budget_lines

3636: END IF;
3637: END IF;
3638:
3639: FORALL j IN 1..l_budget_line_id_tab.count
3640: UPDATE pa_budget_lines
3641: SET start_date = l_min_start_date,
3642: end_date = l_max_end_date
3643: WHERE budget_line_id = l_budget_line_id_tab(j);
3644: