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

Line 54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;

50: l_running_pc_rev NUMBER := 0;
51: l_ratio NUMBER;
52:
53: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;
55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

Line 55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;

51: l_ratio NUMBER;
52:
53: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;
55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;

Line 56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;

52:
53: l_plan_class_code PA_FIN_PLAN_TYPES_B.PLAN_CLASS_CODE%TYPE;
54: l_init_rev_sum PA_BUDGET_LINES.INIT_REVENUE%TYPE := 0;
55: l_pc_init_rev_sum PA_BUDGET_LINES.PROJECT_INIT_REVENUE%TYPE := 0;
56: l_burdened_cost_sum PA_BUDGET_LINES.BURDENED_COST%TYPE;
57:
58: l_appr_cost_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
59: l_appr_rev_plan_type_flag PA_BUDGET_VERSIONS.APPROVED_COST_PLAN_TYPE_FLAG%TYPE;
60: l_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE;

Line 76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

72: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
73: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;
79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

Line 78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;

74: l_eliminated_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;
79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
81:
82: l_upd_count NUMBER := 0;

Line 79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

75:
76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;
79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
81:
82: l_upd_count NUMBER := 0;
83: l_del_count NUMBER := 0;

Line 80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;

76: l_budget_line_id_tmp PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
77: l_res_asg_id_tmp PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
78: l_start_date_tmp PA_BUDGET_LINES.START_DATE%TYPE;
79: l_txn_currency_code_tmp PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
80: l_budget_line_id_dup PA_BUDGET_LINES.BUDGET_LINE_ID%TYPE;
81:
82: l_upd_count NUMBER := 0;
83: l_del_count NUMBER := 0;
84: l_dup_bl_id NUMBER;

Line 108: l_pc_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE := 0;

104:
105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: --Added foll 3 variables for bug 4127427 to calculate l_ratio for PC seperately
108: l_pc_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE := 0;
109: l_pc_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0;
110: l_ratio_pc NUMBER;
111:
112: /* Variables added for Bug 4549862 */

Line 109: l_pc_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0;

105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: --Added foll 3 variables for bug 4127427 to calculate l_ratio for PC seperately
108: l_pc_burdened_cost PA_BUDGET_LINES.PROJECT_BURDENED_COST%TYPE := 0;
109: l_pc_revenue PA_BUDGET_LINES.PROJECT_REVENUE%TYPE := 0;
110: l_ratio_pc NUMBER;
111:
112: /* Variables added for Bug 4549862 */
113: l_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

Line 233: FROM pa_budget_lines bl

229: AND rbc.resource_assignment_id = ra.resource_assignment_id
230: AND (ra.transaction_source_code IS NOT NULL
231: OR (ra.transaction_source_code IS NULL
232: AND NOT EXISTS (SELECT null
233: FROM pa_budget_lines bl
234: WHERE bl.resource_assignment_id =
235: ra.resource_assignment_id )));
236: END IF; -- x_gen_ret_manual_line_flag check
237:

Line 493: FROM pa_budget_lines

489: SELECT nvl(sum(nvl(init_revenue,0)),0),
490: nvl(sum(nvl(project_init_revenue,0)),0)
491: INTO l_init_rev_sum,
492: l_pc_init_rev_sum
493: FROM pa_budget_lines
494: WHERE budget_version_id = p_budget_version_id
495: AND start_date <= p_etc_start_date - 1;
496: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
497: SELECT nvl(sum(nvl(init_revenue,0)),0),

Line 501: FROM pa_budget_lines

497: SELECT nvl(sum(nvl(init_revenue,0)),0),
498: nvl(sum(nvl(project_init_revenue,0)),0)
499: INTO l_init_rev_sum,
500: l_pc_init_rev_sum
501: FROM pa_budget_lines
502: WHERE budget_version_id = p_budget_version_id;
503: END IF;
504:
505: IF p_pa_debug_mode = 'Y' THEN

Line 597: -- from PA_BUDGET_LINES using the existing logic.

593: -- Note that checking l_gen_src_code determines this scenario, since
594: -- accrual method is COST for the entire API and generation of Revenue-
595: -- only versions from Staffing Plan is not supported.
596: -- In all other cases, fetch burdened cost sums and individual records
597: -- from PA_BUDGET_LINES using the existing logic.
598:
599: IF l_gen_src_code = 'RESOURCE_SCHEDULE' THEN
600:
601: IF l_plan_class_code = 'BUDGET' THEN

Line 761: FROM pa_budget_lines bl,

757: SELECT nvl(sum(nvl(bl.burdened_cost,0)),0),
758: nvl(sum(nvl(bl.project_burdened_cost,0)),0)
759: INTO l_pfc_burdened_cost,
760: l_pc_burdened_cost
761: FROM pa_budget_lines bl,
762: pa_resource_assignments ra,
763: pa_tasks ta /* Bug 4546405, ER 4376722 */
764: WHERE bl.budget_version_id = p_budget_version_id
765: AND ra.budget_version_id = p_budget_version_id

Line 787: FROM pa_budget_lines bl,

783: SELECT nvl(sum(nvl(bl.txn_revenue,0)),0),
784: nvl(sum(nvl(bl.project_revenue,0)),0)
785: INTO l_pfc_revenue,
786: l_pc_revenue
787: FROM pa_budget_lines bl,
788: pa_resource_assignments ra,
789: pa_tasks ta /* Bug 4546405, ER 4376722 */
790: WHERE bl.budget_version_id = p_budget_version_id
791: AND ra.budget_version_id = p_budget_version_id

Line 839: FROM pa_budget_lines bl,

835: l_pfc_raw_cost_tab,
836: l_res_asg_id_tab,
837: l_start_date_tab,
838: l_txn_currency_code_tab
839: FROM pa_budget_lines bl,
840: pa_resource_assignments ra,
841: pa_tasks ta /* Bug 4546405, ER 4376722 */
842: WHERE bl.budget_version_id = p_budget_version_id
843: AND ra.budget_version_id = p_budget_version_id

Line 901: FROM pa_budget_lines bl,

897: l_pfc_raw_cost_tab,
898: l_res_asg_id_tab,
899: l_start_date_tab,
900: l_txn_currency_code_tab
901: FROM pa_budget_lines bl,
902: pa_resource_assignments ra,
903: pa_tasks ta /* Bug 4546405, ER 4376722 */
904: WHERE bl.budget_version_id = p_budget_version_id
905: AND ra.budget_version_id = p_budget_version_id

Line 960: FROM pa_budget_lines bl,

956: l_pfc_raw_cost_tab,
957: l_res_asg_id_tab,
958: l_start_date_tab,
959: l_txn_currency_code_tab
960: FROM pa_budget_lines bl,
961: pa_resource_assignments ra,
962: pa_tasks ta /* Bug 4546405, ER 4376722 */
963: WHERE bl.budget_version_id = p_budget_version_id
964: AND ra.budget_version_id = p_budget_version_id

Line 1009: FROM pa_budget_lines bl,

1005: INTO l_pfc_burdened_cost,
1006: l_pfc_revenue,
1007: l_pc_burdened_cost,
1008: l_pc_revenue
1009: FROM pa_budget_lines bl,
1010: pa_resource_assignments ra,
1011: pa_tasks ta /* Bug 4546405, ER 4376722 */
1012: WHERE bl.budget_version_id = p_budget_version_id
1013: AND ra.budget_version_id = p_budget_version_id

Line 1039: FROM pa_budget_lines bl,

1035: INTO l_pfc_burdened_cost,
1036: l_pfc_revenue,
1037: l_pc_burdened_cost,
1038: l_pc_revenue
1039: FROM pa_budget_lines bl,
1040: pa_resource_assignments ra,
1041: pa_tasks ta /* Bug 4546405, ER 4376722 */
1042: WHERE bl.budget_version_id = p_budget_version_id
1043: AND ra.budget_version_id = p_budget_version_id

Line 1309: UPDATE pa_budget_lines

1305:
1306: IF l_cost_or_rev_code = 'COST' THEN
1307: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1308: FORALL j in 1..l_budget_line_id_tab.count
1309: UPDATE pa_budget_lines
1310: SET quantity = l_quantity_tab(j),
1311: txn_revenue = l_txn_rev_tab(j),
1312: txn_bill_rate_override = l_txn_bill_rate_override_tab(j),
1313: revenue = l_txn_rev_tab(j),

Line 1325: UPDATE pa_budget_lines

1321: -- the invariant that planned columns always store the Total amount.
1322: -- We need to add Actuals to Plan amounts.
1323: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1324: FORALL j in 1..l_budget_line_id_tab.count
1325: UPDATE pa_budget_lines
1326: SET quantity = NVL(init_quantity,0) + l_quantity_tab(j),
1327: txn_revenue = NVL(txn_init_revenue,0) + l_txn_rev_tab(j),
1328: txn_bill_rate_override = l_txn_bill_rate_override_tab(j),
1329: revenue = NVL(init_revenue,0) + l_txn_rev_tab(j),

Line 1340: UPDATE pa_budget_lines

1336: END IF; -- time phase check
1337: ELSIF l_cost_or_rev_code = 'REVENUE' THEN
1338: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1339: FORALL jj in 1..l_budget_line_id_tab.count
1340: UPDATE pa_budget_lines
1341: SET quantity = l_txn_rev_tab(jj),
1342: txn_revenue = l_txn_rev_tab(jj),
1343: txn_bill_rate_override = l_txn_bill_rate_override_tab(jj),
1344: revenue = l_txn_rev_tab(jj),

Line 1356: UPDATE pa_budget_lines

1352: -- the invariant that planned columns always store the Total amount.
1353: -- We need to add Actuals to Plan amounts.
1354: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1355: FORALL jj in 1..l_budget_line_id_tab.count
1356: UPDATE pa_budget_lines
1357: SET quantity = NVL(init_quantity,0) + l_txn_rev_tab(jj),
1358: txn_revenue = NVL(txn_init_revenue,0) + l_txn_rev_tab(jj),
1359: txn_bill_rate_override = l_txn_bill_rate_override_tab(jj),
1360: revenue = NVL(init_revenue,0) + l_txn_rev_tab(jj),

Line 1447: UPDATE pa_budget_lines

1443: IF l_cost_or_rev_code = 'COST' THEN
1444:
1445: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1446: FORALL k in 1..l_budget_line_id_tab.count
1447: UPDATE pa_budget_lines
1448: SET quantity = l_quantity_tab(k),
1449: txn_revenue = l_txn_rev_tab(k),
1450: txn_bill_rate_override = l_txn_bill_rate_override_tab(k),
1451: project_rev_rate_type = 'User',

Line 1461: UPDATE pa_budget_lines

1457: -- the invariant that planned columns always store the Total amount.
1458: -- We need to add Actuals to Plan amounts.
1459: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1460: FORALL k in 1..l_budget_line_id_tab.count
1461: UPDATE pa_budget_lines
1462: SET quantity = NVL(init_quantity,0) + l_quantity_tab(k),
1463: txn_revenue = NVL(txn_init_revenue,0) + l_txn_rev_tab(k),
1464: txn_bill_rate_override = l_txn_bill_rate_override_tab(k),
1465: project_rev_rate_type = 'User',

Line 1474: UPDATE pa_budget_lines

1470: END IF; -- time phase check
1471: ELSIF l_cost_or_rev_code = 'REVENUE' THEN
1472: IF p_fp_cols_rec.x_time_phased_code IN ('P','G') THEN
1473: FORALL kk in 1..l_budget_line_id_tab.count
1474: UPDATE pa_budget_lines
1475: SET quantity = l_txn_rev_tab(kk),
1476: txn_revenue = l_txn_rev_tab(kk),
1477: txn_bill_rate_override = l_txn_bill_rate_override_tab(kk),
1478: project_rev_rate_type = 'User',

Line 1488: UPDATE pa_budget_lines

1484: -- the invariant that planned columns always store the Total amount.
1485: -- We need to add Actuals to Plan amounts.
1486: ELSIF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1487: FORALL kk in 1..l_budget_line_id_tab.count
1488: UPDATE pa_budget_lines
1489: SET quantity = NVL(init_quantity,0) + l_txn_rev_tab(kk),
1490: txn_revenue = NVL(txn_init_revenue,0) + l_txn_rev_tab(kk),
1491: txn_bill_rate_override = l_txn_bill_rate_override_tab(kk),
1492: project_rev_rate_type = 'User',

Line 1549: UPDATE pa_budget_lines

1545:
1546: END IF; -- insert/update temp table data to budget lines
1547:
1548: /* IF p_fp_cols_rec.x_version_type = 'REVENUE' THEN
1549: UPDATE pa_budget_lines
1550: SET quantity = null
1551: WHERE budget_version_id = p_budget_version_id;
1552: END IF; */
1553:

Line 1609: * and Inserts/Updates it into PA_BUDGET_LINES. This includes txn/pc/pfc

1605: * when generating a Cost and Revenue together version with source of
1606: * Staffing Plan and revenue accrual method of COST.
1607: *
1608: * This procedure propagates generation data stored in PA_FP_ROLLUP_TMP
1609: * and Inserts/Updates it into PA_BUDGET_LINES. This includes txn/pc/pfc
1610: * amounts, rate overrides, pc/pfc exchange rates, cost/revenue rate types,
1611: * and rejection codes.
1612: *
1613: * This API should always be called by GEN_COST_BASED_REVENUE before

Line 1720: -- Inserted into pa_budget_lines.

1716: -- Bug 4549862: Added cursor for when the target version is None
1717: -- Time Phased and the context is Forecast Generation. In this
1718: -- case, budget lines may exist with actuals. Fetch temp table
1719: -- data for which budget lines do not yet exist, which should be
1720: -- Inserted into pa_budget_lines.
1721: -- The query is the same as that of GROUP_TO_INS_INTO_NTP_BDGT_BL
1722: -- but with an additional HAVING clause to find Insert records.
1723:
1724: CURSOR GROUP_TO_INS_INTO_NTP_FCST_BL IS

Line 1761: FROM pa_budget_lines bl

1757: PROJFUNC_COST_RATE_TYPE,
1758: PROJECT_REV_RATE_TYPE,
1759: PROJFUNC_REV_RATE_TYPE
1760: HAVING ( SELECT count(*)
1761: FROM pa_budget_lines bl
1762: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1763: AND tmp.txn_currency_code = bl.txn_currency_code ) = 0;
1764:
1765: -- Bug 4549862: Added cursor for when the target version is None

Line 1769: -- into pa_budget_lines.

1765: -- Bug 4549862: Added cursor for when the target version is None
1766: -- Time Phased and the context is Forecast Generation. In this
1767: -- case, budget lines may exist with actuals. Fetch temp table
1768: -- data for which budget lines exist, which whould be Updated
1769: -- into pa_budget_lines.
1770: -- The query is the same as that of GROUP_TO_INS_INTO_NTP_BDGT_BL
1771: -- but with an additional HAVING clause to find Update records.
1772:
1773: CURSOR GROUP_TO_UPD_INTO_NTP_FCST_BL IS

Line 1810: FROM pa_budget_lines bl

1806: PROJFUNC_COST_RATE_TYPE,
1807: PROJECT_REV_RATE_TYPE,
1808: PROJFUNC_REV_RATE_TYPE
1809: HAVING ( SELECT count(*)
1810: FROM pa_budget_lines bl
1811: WHERE tmp.resource_assignment_id = bl.resource_assignment_id
1812: AND tmp.txn_currency_code = bl.txn_currency_code ) > 0;
1813:
1814: /* Variables added for Bug 4549862 */

Line 2010: -- may need to be Updated in pa_budget_lines.

2006: -- Bug 4549862: If the target version is None timephased and the
2007: -- context is Forecast generation, then budget lines containing
2008: -- actuals may exist. As a result, some of the data in the temp
2009: -- table may need to be Inserted while other data in the table
2010: -- may need to be Updated in pa_budget_lines.
2011: --
2012: -- Group the temporary table data by resource assignment and txn
2013: -- currency code using separate cursors for the Insert/Update cases.
2014: -- Note that there are some cursors in GENERATE_BUDGET_AMT_RES_SCH

Line 2237: INSERT INTO PA_BUDGET_LINES(

2233:
2234: IF l_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
2235:
2236: FORALL bl_index IN 1 .. l_bl_START_DATE_tab.COUNT
2237: INSERT INTO PA_BUDGET_LINES(
2238: RESOURCE_ASSIGNMENT_ID,
2239: START_DATE,
2240: LAST_UPDATE_DATE,
2241: LAST_UPDATED_BY,

Line 2289: PA_BUDGET_LINES_S.nextval,

2285: l_bl_END_DATE_tab(bl_index),
2286: l_bl_PERIOD_NAME_tab(bl_index),
2287: l_bl_QUANTITY_tab(bl_index),
2288: l_bl_TXN_CURRENCY_CODE_tab(bl_index),
2289: PA_BUDGET_LINES_S.nextval,
2290: P_BUDGET_VERSION_ID,
2291: P_FP_COLS_REC.X_PROJECT_CURRENCY_CODE,
2292: P_FP_COLS_REC.X_PROJFUNC_CURRENCY_CODE,
2293: l_txn_rcost_rate_override_tab(bl_index),

Line 2325: -- may need to be Updated in pa_budget_lines.

2321: -- Bug 4549862: If the target version is None timephased and the
2322: -- context is Forecast generation, then budget lines containing
2323: -- actuals may exist. As a result, some of the data in the temp
2324: -- table may need to be Inserted while other data in the table
2325: -- may need to be Updated in pa_budget_lines.
2326: --
2327: -- The following code Updates the budget lines.
2328:
2329: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN

Line 2332: UPDATE PA_BUDGET_LINES

2328:
2329: IF l_upd_bl_RES_ASSIGNMENT_ID_tab.COUNT > 0 THEN
2330:
2331: FORALL bl_index IN 1 .. l_upd_bl_START_DATE_tab.COUNT
2332: UPDATE PA_BUDGET_LINES
2333: SET LAST_UPDATE_DATE = l_sysdate,
2334: LAST_UPDATED_BY = l_last_updated_by,
2335: LAST_UPDATE_LOGIN = l_last_update_login,
2336: START_DATE = LEAST(START_DATE, l_upd_bl_START_DATE_tab(bl_index)),