APPS.PA_FP_UPGRADE_PKG dependencies on PA_BUDGET_LINES

Line 2306: UPDATE PA_BUDGET_LINES

2302: pa_debug.g_err_stage := 'Updating budget lines for '|| l_budget_ver_tbl(j);
2303: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2304: END IF;
2305:
2306: UPDATE PA_BUDGET_LINES
2307: SET txn_raw_cost = raw_cost,
2308: txn_burdened_cost = burdened_cost,
2309: txn_revenue = revenue
2310: WHERE budget_version_id = l_budget_ver_tbl(j);

Line 2466: FROM PA_BUDGET_LINES BL

2462: --Bug 4300363. Budget lines should not exist with NULL amounts. Below code does
2463: --the required processing for correcting such budget lines
2464:
2465: DELETE
2466: FROM PA_BUDGET_LINES BL
2467: WHERE bl.budget_version_id = l_budget_ver_tbl(m)
2468: AND NVL(bl.quantity,0) = 0
2469: AND NVL(bl.txn_raw_cost,0) = 0
2470: AND NVL(bl.txn_burdened_cost,0) = 0

Line 2488: FROM pa_budget_lines bl

2484: ,l_upg_txn_raw_cost_tbl
2485: ,l_upg_txn_burdened_cost_tbl
2486: ,l_upg_txn_revenue_tbl
2487: ,l_upg_rate_based_flag_tbl
2488: FROM pa_budget_lines bl
2489: ,pa_resource_assignments ra
2490: WHERE bl.resource_assignment_id=ra.resource_assignment_id
2491: AND bl.budget_version_id=l_budget_ver_tbl(m)
2492: ORDER BY bl.resource_assignment_id ,bl.quantity NULLS FIRST;

Line 2546: UPDATE PA_BUDGET_LINES bl

2542: WHERE ra.resource_assignment_id = l_upg_non_rb_ra_id_tbl(j);
2543:
2544: FORALL j IN l_upg_bl_id_tbl.first .. l_upg_bl_id_tbl.last
2545:
2546: UPDATE PA_BUDGET_LINES bl
2547: SET bl.quantity = l_upg_quantity_tbl(j)
2548: ,bl.txn_raw_cost = l_upg_txn_raw_cost_tbl(j)
2549: ,bl.txn_cost_rate_override = l_upg_raw_cost_rate_tbl(j)
2550: ,bl.txn_standard_cost_rate = l_upg_raw_cost_rate_tbl(j)

Line 2605: * i. update the display_quantity new column in pa_budget_lines

2601: raise PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
2602: END IF;
2603: */
2604: /* bug 4865563: IPM Changes. Calling APIs which take care of
2605: * i. update the display_quantity new column in pa_budget_lines
2606: * ii. insert planning transaction records in the new entity pa_resource_asgn_curr
2607: * with the appropriate records.
2608: */
2609: PA_BUDGET_LINES_UTILS.populate_display_qty

Line 2609: PA_BUDGET_LINES_UTILS.populate_display_qty

2605: * i. update the display_quantity new column in pa_budget_lines
2606: * ii. insert planning transaction records in the new entity pa_resource_asgn_curr
2607: * with the appropriate records.
2608: */
2609: PA_BUDGET_LINES_UTILS.populate_display_qty
2610: (p_budget_version_id => l_budget_ver_tbl(m),
2611: p_context => 'FINANCIAL',
2612: x_return_status => l_return_status);
2613:

Line 2617: pa_debug.write_file('Upgrade failed due to error in PA_BUDGET_LINES_UTILS.populate_display_quantity',5);

2613:
2614: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
2615: THEN
2616: IF p_pa_debug_mode = 'Y' THEN
2617: pa_debug.write_file('Upgrade failed due to error in PA_BUDGET_LINES_UTILS.populate_display_quantity',5);
2618: END IF;
2619: raise PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
2620: END IF;
2621:

Line 4406: and EXISTS (SELECT 1 FROM pa_budget_lines bl

4402: and NOT EXISTS (SELECT 1 FROM pa_fp_upgrade_audit aud
4403: WHERE aud.project_id = op.project_id
4404: AND aud.proj_fp_options_id_rup = op.PROJ_FP_OPTIONS_ID
4405: AND aud.upgraded_flag = 'Y')
4406: and EXISTS (SELECT 1 FROM pa_budget_lines bl
4407: WHERE bl.budget_version_id = bv.budget_version_id
4408: AND ( bl.cost_rejection_code IS NOT NULL
4409: OR bl.revenue_rejection_code IS NOT NULL
4410: OR bl.burden_rejection_code IS NOT NULL

Line 4650: INSERT INTO pa_budget_lines_m_upg_dtrange(

4646:
4647: -- Auditing the RA ID records.
4648: FORALL i IN l_ra_id_tbl.FIRST..l_ra_id_tbl.LAST
4649: -- SAVE EXCEPTIONS
4650: INSERT INTO pa_budget_lines_m_upg_dtrange(
4651: LAST_UPDATE_DATE
4652: ,LAST_UPDATED_BY
4653: ,CREATION_DATE
4654: ,CREATED_BY