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

Line 1646: -- PA_BUDGET_LINES: delete row (keyed on PA_RESOURCE_ASSIGNMENTS.resource_assignment_id)

1642: ---- start of changes for bug 2779637 ----
1643: /* for performance its better to use budget_version_id for the deletion of budget lines*/
1644:
1645: /*
1646: -- PA_BUDGET_LINES: delete row (keyed on PA_RESOURCE_ASSIGNMENTS.resource_assignment_id)
1647: open l_resource_assignments_csr;
1648: loop
1649: fetch l_resource_assignments_csr into l_resource_assignments_rec;
1650: exit when l_resource_assignments_csr%NOTFOUND;

Line 1653: pa_budget_lines

1649: fetch l_resource_assignments_csr into l_resource_assignments_rec;
1650: exit when l_resource_assignments_csr%NOTFOUND;
1651: delete
1652: from
1653: pa_budget_lines
1654: where
1655: resource_assignment_id=l_resource_assignments_rec.resource_assignment_id;
1656: end loop;
1657: close l_resource_assignments_csr;

Line 1662: pa_budget_lines

1658: */
1659: FORALL i IN 1..l_budget_Version_id_tbl.COUNT
1660: delete
1661: from
1662: pa_budget_lines
1663: where
1664: budget_version_id=l_budget_Version_id_tbl(i);
1665: ---- end of changes for bug 2779637 ----
1666:

Line 2053: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv

2049:
2050: Cursor chk_tgt_ver_status is
2051: Select 'Y' from dual
2052: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )
2053: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv
2054: where pbv.budget_version_id = px_target_version_id
2055: and pbv.budget_version_id = bl.budget_version_id
2056: and (bl.cost_rejection_code IS NOT NULL
2057: OR bl.revenue_rejection_code IS NOT NULL

Line 2498: --Calling convert_txn_currency to complete pa_budget_lines by converting

2494:
2495:
2496: END IF;
2497:
2498: --Calling convert_txn_currency to complete pa_budget_lines by converting
2499: --txn currency'amounts into project projfunc amounts for finplan.
2500:
2501: --Bug 4290043. IF the target version can have missing amounts which will be derived during copyu
2502: --then the PC/PFC amounts should be rederived. Note that even if l_derv_rates_missing_amts_flag is Y,

Line 2796: --Calling populate_display_qty for populating display_quantity in pa_budget_lines

2792:
2793: l_src_version_type :=l_src_fp_cols_rec.x_version_type;
2794: l_target_version_type :=l_fp_cols_rec.x_version_type;
2795:
2796: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
2797: PA_BUDGET_LINES_UTILS.populate_display_qty
2798: (p_budget_version_id => l_budget_version_id,
2799: p_context => 'FINANCIAL',
2800: p_use_temp_table_flag => 'N',

Line 2797: PA_BUDGET_LINES_UTILS.populate_display_qty

2793: l_src_version_type :=l_src_fp_cols_rec.x_version_type;
2794: l_target_version_type :=l_fp_cols_rec.x_version_type;
2795:
2796: --Calling populate_display_qty for populating display_quantity in pa_budget_lines
2797: PA_BUDGET_LINES_UTILS.populate_display_qty
2798: (p_budget_version_id => l_budget_version_id,
2799: p_context => 'FINANCIAL',
2800: p_use_temp_table_flag => 'N',
2801: x_return_status => l_return_status);

Line 2805: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';

2801: x_return_status => l_return_status);
2802:
2803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2804: IF P_PA_debug_mode = 'Y' THEN
2805: pa_debug.g_err_stage:= 'Error in PA_BUDGET_LINES_UTILS.populate_display_qty';
2806: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
2807: END IF;
2808: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2809: END IF;

Line 7172: --Fetch MIN and MAX of start dates of pa_budget_lines

7168: ,x_start_period_start_date => l_start_date
7169: ,x_end_period_end_date => l_end_date);
7170:
7171: ELSE
7172: --Fetch MIN and MAX of start dates of pa_budget_lines
7173:
7174: pa_debug.g_err_stage := 'Selecting start and end dates from pa_budget_lines of the project';
7175: IF P_PA_DEBUG_MODE = 'Y' THEN
7176: pa_debug.write('Create_Fresh_Period_Profile: ' || l_module_name,pa_debug.g_err_stage,3);

Line 7174: pa_debug.g_err_stage := 'Selecting start and end dates from pa_budget_lines of the project';

7170:
7171: ELSE
7172: --Fetch MIN and MAX of start dates of pa_budget_lines
7173:
7174: pa_debug.g_err_stage := 'Selecting start and end dates from pa_budget_lines of the project';
7175: IF P_PA_DEBUG_MODE = 'Y' THEN
7176: pa_debug.write('Create_Fresh_Period_Profile: ' || l_module_name,pa_debug.g_err_stage,3);
7177: END IF;
7178:

Line 7184: ,pa_budget_lines pbl

7180: ,MAX(pbl.end_date)
7181: INTO l_start_date
7182: ,l_end_date
7183: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7184: ,pa_budget_lines pbl
7185: WHERE pbv.project_id = p_project_id
7186: AND pbl.budget_version_id = pbv.budget_version_id
7187: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)
7188: = DECODE(p_period_type,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,

Line 7772: FROM pa_resource_assignments pra, pa_budget_lines pbl

7768: ,null old_projfunc_margin_percent
7769: ,bucketing_period_code
7770: ,pra.parent_assignment_id
7771: ,null delete_flag
7772: FROM pa_resource_assignments pra, pa_budget_lines pbl
7773: WHERE pra.budget_version_id = p_budget_version_id
7774: AND pra.resource_assignment_id = pbl.resource_assignment_id;
7775:
7776: CURSOR rollup_tmp_cur IS

Line 8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;

8485: WHERE rac.resource_assignment_id = ra.resource_assignment_id
8486: AND rac.budget_version_id = ra.budget_version_id);
8487:
8488: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;