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_BUDGET_PUB dependencies on PA_FIN_PLAN_PVT

Line 251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

247: l_time_phased_type_code pa_budget_entry_methods.time_phased_type_code%TYPE;
248: l_categorization_code pa_budget_entry_methods.categorization_code%TYPE;
249: l_entry_level_code pa_budget_entry_methods.entry_level_code%TYPE;
250: l_amg_segment1 pa_projects_all.segment1%TYPE;
251: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
252: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
253: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
254: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
255: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;

Line 2050: pa_fin_plan_pvt.lock_unlock_version

2046:
2047: --Get the record version number of the current working version
2048: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
2049:
2050: pa_fin_plan_pvt.lock_unlock_version
2051: (p_budget_version_id => l_CW_version_id,
2052: p_record_version_number => l_CW_record_version_number,
2053: p_action => 'L',
2054: p_user_id => l_user_id,

Line 2075: PA_FIN_PLAN_PVT.CREATE_DRAFT(

2071:
2072: END IF;--IF (p_replace_current_working_flag = 'Y' OR
2073:
2074: --Call the api that creates the fin plan version
2075: PA_FIN_PLAN_PVT.CREATE_DRAFT(
2076: p_project_id => l_project_id
2077: ,p_fin_plan_type_id => l_fin_plan_type_id
2078: ,p_version_type => l_version_type
2079: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.

Line 2153: pa_fin_plan_pvt.lock_unlock_version

2149: AND l_CW_version_id IS NOT NULL
2150: AND l_locked_by_person_id IS NULL THEN
2151: --Get the record version number of the current working version
2152: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
2153: pa_fin_plan_pvt.lock_unlock_version
2154: (p_budget_version_id => l_CW_version_id,
2155: p_record_version_number => l_CW_record_version_number,
2156: p_action => 'U',
2157: p_user_id => l_user_id,

Line 3807: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

3803:
3804: --Changed p_fin_plan_type_id to ll_fin_plan_type_id,
3805: -- p_fin_plan_type_name to ll_fin_plan_type_name
3806: --Xin Liu 28-APR-03
3807: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
3808: ( p_fin_plan_type_id => ll_fin_plan_type_id
3809: ,p_fin_plan_type_name => ll_fin_plan_type_name
3810: ,x_fin_plan_type_id => l_fin_plan_type_id
3811: ,x_return_status => l_return_status

Line 4442: pa_fin_plan_pvt.lock_unlock_version

4438: l_CW_record_version_number :=pa_fin_plan_utils.Retrieve_Record_Version_Number(l_curr_working_version_id);
4439:
4440: -- Lock the current working version
4441:
4442: pa_fin_plan_pvt.lock_unlock_version
4443: (p_budget_version_id => l_curr_working_version_id,
4444: p_record_version_number => l_CW_record_version_number,
4445: p_action => 'L',
4446: p_user_id => l_user_id,

Line 4844: pa_fin_plan_pvt.lock_unlock_version

4840: END IF;
4841:
4842: --Bug 6453987 - skkoppul - Unlocking the working version
4843:
4844: pa_fin_plan_pvt.lock_unlock_version
4845: (p_budget_version_id => l_curr_working_version_id,
4846: p_record_version_number => l_CW_record_version_number,
4847: p_action => 'U',
4848: p_user_id => l_user_id,

Line 5090: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

5086: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5087: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5088: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5089:
5090: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5091: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
5092:
5093: --Following parameters are needed for amounts check
5094: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

Line 5761: PA_FIN_PLAN_PVT.lock_unlock_version

5757: --Lock the budget version before inserting a budget line
5758: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
5759: (p_budget_version_id => l_budget_version_id);
5760:
5761: PA_FIN_PLAN_PVT.lock_unlock_version
5762: ( p_budget_version_id => l_budget_version_id
5763: ,p_record_version_number => l_record_version_number
5764: ,p_action => 'L'
5765: ,p_user_id => FND_GLOBAL.User_id

Line 5781: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of inserting

5777: END IF;
5778: RAISE FND_API.G_EXC_ERROR;
5779: END IF;
5780:
5781: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of inserting
5782: --budget lines data in all relevant tables.
5783: PA_FIN_PLAN_PVT.add_fin_plan_lines
5784: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.
5785: ,p_fin_plan_version_id => l_budget_version_id

Line 5783: PA_FIN_PLAN_PVT.add_fin_plan_lines

5779: END IF;
5780:
5781: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of inserting
5782: --budget lines data in all relevant tables.
5783: PA_FIN_PLAN_PVT.add_fin_plan_lines
5784: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.
5785: ,p_fin_plan_version_id => l_budget_version_id
5786: ,p_finplan_lines_tab => l_finplan_lines_tab
5787: ,x_return_status => p_return_status

Line 5794: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';

5790:
5791: IF p_return_status <> FND_API.G_RET_STS_SUCCESS
5792: THEN
5793: IF(l_debug_mode='Y') THEN
5794: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';
5795: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5796: END IF;
5797: RAISE FND_API.G_EXC_ERROR;
5798: END IF;

Line 5805: PA_FIN_PLAN_PVT.lock_unlock_version

5801: --unlock the budget version after inserting the budget line
5802: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
5803: (p_budget_version_id => l_budget_version_id);
5804:
5805: PA_FIN_PLAN_PVT.lock_unlock_version
5806: ( p_budget_version_id => l_budget_version_id
5807: ,p_record_version_number => l_record_version_number
5808: ,p_action => 'U'
5809: ,p_user_id => FND_GLOBAL.User_id

Line 6527: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

6523: ELSE -- Fin Plan Model
6524:
6525:
6526: -- validate the plan type passed
6527: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
6528: ( p_fin_plan_type_id => ll_fin_plan_type_id
6529: ,p_fin_plan_type_name => ll_fin_plan_type_name
6530: ,x_fin_plan_type_id => l_fin_plan_type_id
6531: ,x_return_status => p_return_status

Line 6733: pa_fin_plan_pvt.lock_unlock_version

6729:
6730: --Lock the version before deleting it
6731: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
6732: (p_budget_version_id => l_budget_version_id);
6733: pa_fin_plan_pvt.lock_unlock_version
6734: ( p_budget_version_id => l_budget_version_id
6735: ,p_record_version_number => l_record_version_number
6736: ,p_action => 'L'
6737: ,p_user_id => l_user_id

Line 6966: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

6962: -- FND_API.compatible_api_call
6963: -- PA_PROJECT_PVT.convert_pm_projref_to_id
6964: -- PA_PM_FUNCTION_SECURITY_PUB.check_budget_security
6965: -- PA_BUDGET_UTILS.delete_draft
6966: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
6967: -- PA_FIN_PLAN_UTILS.get_version_type
6968: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
6969: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number
6970: -- PA_FIN_PLAN_PVT.lock_unlock_version

Line 6970: -- PA_FIN_PLAN_PVT.lock_unlock_version

6966: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
6967: -- PA_FIN_PLAN_UTILS.get_version_type
6968: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
6969: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number
6970: -- PA_FIN_PLAN_PVT.lock_unlock_version
6971: -- PA_FIN_PLAN_PUB.delete_version
6972: --
6973: --History:
6974: -- 05-APR-2005 Rishukla Created.

Line 7542: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

7538:
7539: ELSE --finplan model
7540:
7541: --validate the plan type passed
7542: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
7543: ( p_fin_plan_type_id => l_fin_plan_type_id
7544: ,p_fin_plan_type_name => l_fin_plan_type_name
7545: ,x_fin_plan_type_id => l_fin_plan_type_id
7546: ,x_return_status => p_return_status

Line 8725: PA_FIN_PLAN_PVT.lock_unlock_version

8721: --Lock the budget version before deleting a budget line
8722: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
8723: (p_budget_version_id => l_budget_version_id);
8724:
8725: PA_FIN_PLAN_PVT.lock_unlock_version
8726: ( p_budget_version_id => l_budget_version_id
8727: ,p_record_version_number => l_record_version_number
8728: ,p_action => 'L'
8729: ,p_user_id => FND_GLOBAL.User_id

Line 8795: PA_FIN_PLAN_PVT.lock_unlock_version

8791: --unlock the budget version after deleting the budget line
8792: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
8793: (p_budget_version_id => l_budget_version_id);
8794:
8795: PA_FIN_PLAN_PVT.lock_unlock_version
8796: ( p_budget_version_id => l_budget_version_id
8797: ,p_record_version_number => l_record_version_number
8798: ,p_action => 'U'
8799: ,p_user_id => FND_GLOBAL.User_id

Line 9325: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

9321: l_debug_level5 CONSTANT NUMBER :=5;
9322: l_baselined_Ver_options_id VARCHAR2(15);
9323: l_budget_lines_in budget_line_in_tbl_type;
9324: l_debug_level3 CONSTANT NUMBER := 3;
9325: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9326: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9327: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9328: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9329: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;

Line 9708: pa_fin_plan_pvt.lock_unlock_version

9704: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
9705: (p_budget_version_id => l_budget_version_id);
9706:
9707: --Try to lock the version before updating the version. This is required so that nobody else can access it.
9708: pa_fin_plan_pvt.lock_unlock_version
9709: (p_budget_version_id => l_budget_version_id,
9710: p_record_version_number => l_record_version_number,
9711: p_action => 'L',
9712: p_user_id => l_user_id,

Line 10308: pa_fin_plan_pvt.lock_unlock_version

10304:
10305: --Get the record version number of the version to be updated
10306: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_budget_version_id);
10307:
10308: pa_fin_plan_pvt.lock_unlock_version
10309: (p_budget_version_id => l_CW_version_id,
10310: p_record_version_number => l_CW_record_version_number,
10311: p_action => 'L',
10312: p_user_id => l_user_id,

Line 12390: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES

12386: IF ( nvl(l_finplan_lines_tab.last,0) > 0 ) THEN
12387:
12388: -- dbms_output.put_line ('Calling add_finplan_lines');
12389:
12390: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES
12391: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API /* Bug# 2674353 */
12392: ,p_fin_plan_version_id => l_budget_version_id
12393: ,p_finplan_lines_tab => l_finplan_lines_tab
12394: ,x_return_status => l_return_status

Line 12415: pa_fin_plan_pvt.lock_unlock_version

12411: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
12412: (p_budget_version_id => l_budget_version_id);
12413:
12414: --Try to lock the version before updating the version. This is required so that nobody else can access it.
12415: pa_fin_plan_pvt.lock_unlock_version
12416: (p_budget_version_id => l_budget_version_id,
12417: p_record_version_number => l_record_version_number,
12418: p_action => 'U',
12419: p_user_id => l_user_id,

Line 13054: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

13050: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13051: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
13052: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13053:
13054: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
13055: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
13056:
13057: --Following parameters are needed for amounts check
13058: l_amount_set_id NUMBER;

Line 13838: PA_FIN_PLAN_PVT.lock_unlock_version

13834: --Lock the budget version before updating a budget line
13835: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
13836: (p_budget_version_id => l_budget_version_id);
13837:
13838: PA_FIN_PLAN_PVT.lock_unlock_version
13839: ( p_budget_version_id => l_budget_version_id
13840: ,p_record_version_number => l_record_version_number
13841: ,p_action => 'L'
13842: ,p_user_id => FND_GLOBAL.User_id

Line 13858: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of updating

13854: END IF;
13855: RAISE FND_API.G_EXC_ERROR;
13856: END IF;
13857:
13858: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of updating
13859: --budget lines data in all relevant tables.
13860: PA_FIN_PLAN_PVT.add_fin_plan_lines
13861: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API
13862: ,p_fin_plan_version_id => l_budget_version_id

Line 13860: PA_FIN_PLAN_PVT.add_fin_plan_lines

13856: END IF;
13857:
13858: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of updating
13859: --budget lines data in all relevant tables.
13860: PA_FIN_PLAN_PVT.add_fin_plan_lines
13861: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API
13862: ,p_fin_plan_version_id => l_budget_version_id
13863: ,p_finplan_lines_tab => l_finplan_lines_tab
13864: ,x_return_status => p_return_status

Line 13871: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';

13867:
13868: IF p_return_status <> FND_API.G_RET_STS_SUCCESS
13869: THEN
13870: IF(l_debug_mode='Y') THEN
13871: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';
13872: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
13873: END IF;
13874: RAISE FND_API.G_EXC_ERROR;
13875: END IF;

Line 13882: PA_FIN_PLAN_PVT.lock_unlock_version

13878: --unlock the budget version after updating the budget line
13879: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
13880: (p_budget_version_id => l_budget_version_id);
13881:
13882: PA_FIN_PLAN_PVT.lock_unlock_version
13883: ( p_budget_version_id => l_budget_version_id
13884: ,p_record_version_number => l_record_version_number
13885: ,p_action => 'U'
13886: ,p_user_id => FND_GLOBAL.User_id

Line 14925: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

14921: -- Change the p_fin_plan_type_id, p_fin_plan_type_name to
14922: -- ll_fin_plan_type_id,ll_fin_plan_type_name
14923: -- Xin Liu. 28-APR-03
14924:
14925: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
14926: ( p_fin_plan_type_id => ll_fin_plan_type_id
14927: ,p_fin_plan_type_name => ll_fin_plan_type_name
14928: ,x_fin_plan_type_id => l_fin_plan_type_id
14929: ,x_return_status => p_return_status

Line 15445: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION

15441: -- Fetch the record version number of the plan version
15442: l_record_version_number :=
15443: PA_FIN_PLAN_UTILS.RETRIEVE_RECORD_VERSION_NUMBER(l_budget_version_id);
15444:
15445: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION
15446: ( p_budget_version_id => l_budget_version_id
15447: ,p_record_version_number => l_record_version_number
15448: ,p_action => 'L'
15449: ,p_user_id => FND_GLOBAL.User_id

Line 16509: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION

16505: -- Fetch the record version number of the plan version
16506: l_record_version_number :=
16507: PA_FIN_PLAN_UTILS.RETRIEVE_RECORD_VERSION_NUMBER(l_budget_version_id);
16508:
16509: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION
16510: ( p_budget_version_id => l_budget_version_id
16511: ,p_record_version_number => l_record_version_number
16512: ,p_action => 'U'
16513: ,p_user_id => FND_GLOBAL.User_id

Line 17690: pa_fin_plan_pvt.lock_unlock_version

17686:
17687: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
17688: (p_budget_version_id => l_curr_work_version_id);
17689: l_user_id := FND_GLOBAL.User_id;
17690: pa_fin_plan_pvt.lock_unlock_version
17691: (p_budget_version_id => l_curr_work_version_id,
17692: p_record_version_number => l_record_version_number,
17693: p_action => 'L',
17694: p_user_id => l_user_id,

Line 18542: --dbms_output.put_line('pa_fin_plan_pvt.lock_unlock_version');

18538: (p_user_id => l_user_id,
18539: x_person_id => t_person_id,
18540: x_resource_id => t_resource_id,
18541: x_resource_name => t_resource_name);
18542: --dbms_output.put_line('pa_fin_plan_pvt.lock_unlock_version');
18543: pa_fin_plan_pvt.lock_unlock_version
18544: (p_budget_version_id => l_CW_version_id,
18545: p_record_version_number => l_CW_record_version_number,
18546: p_action => 'L',

Line 18543: pa_fin_plan_pvt.lock_unlock_version

18539: x_person_id => t_person_id,
18540: x_resource_id => t_resource_id,
18541: x_resource_name => t_resource_name);
18542: --dbms_output.put_line('pa_fin_plan_pvt.lock_unlock_version');
18543: pa_fin_plan_pvt.lock_unlock_version
18544: (p_budget_version_id => l_CW_version_id,
18545: p_record_version_number => l_CW_record_version_number,
18546: p_action => 'L',
18547: p_user_id => l_user_id,