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 2075: pa_fin_plan_pvt.lock_unlock_version

2071:
2072: --Get the record version number of the current working version
2073: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
2074:
2075: pa_fin_plan_pvt.lock_unlock_version
2076: (p_budget_version_id => l_CW_version_id,
2077: p_record_version_number => l_CW_record_version_number,
2078: p_action => 'L',
2079: p_user_id => l_user_id,

Line 2100: PA_FIN_PLAN_PVT.CREATE_DRAFT(

2096:
2097: END IF;--IF (p_replace_current_working_flag = 'Y' OR
2098:
2099: --Call the api that creates the fin plan version
2100: PA_FIN_PLAN_PVT.CREATE_DRAFT(
2101: p_project_id => l_project_id
2102: ,p_fin_plan_type_id => l_fin_plan_type_id
2103: ,p_version_type => l_version_type
2104: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.

Line 2179: pa_fin_plan_pvt.lock_unlock_version

2175: AND l_CW_version_id IS NOT NULL
2176: AND l_locked_by_person_id IS NULL THEN
2177: --Get the record version number of the current working version
2178: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
2179: pa_fin_plan_pvt.lock_unlock_version
2180: (p_budget_version_id => l_CW_version_id,
2181: p_record_version_number => l_CW_record_version_number,
2182: p_action => 'U',
2183: p_user_id => l_user_id,

Line 3879: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

3875:
3876: --Changed p_fin_plan_type_id to ll_fin_plan_type_id,
3877: -- p_fin_plan_type_name to ll_fin_plan_type_name
3878: --Xin Liu 28-APR-03
3879: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
3880: ( p_fin_plan_type_id => ll_fin_plan_type_id
3881: ,p_fin_plan_type_name => ll_fin_plan_type_name
3882: ,x_fin_plan_type_id => l_fin_plan_type_id
3883: ,x_return_status => l_return_status

Line 4548: pa_fin_plan_pvt.lock_unlock_version

4544: l_CW_record_version_number :=pa_fin_plan_utils.Retrieve_Record_Version_Number(l_curr_working_version_id);
4545:
4546: -- Lock the current working version
4547:
4548: pa_fin_plan_pvt.lock_unlock_version
4549: (p_budget_version_id => l_curr_working_version_id,
4550: p_record_version_number => l_CW_record_version_number,
4551: p_action => 'L',
4552: p_user_id => l_user_id,

Line 4950: pa_fin_plan_pvt.lock_unlock_version

4946: END IF;
4947:
4948: --Bug 6453987 - skkoppul - Unlocking the working version
4949:
4950: pa_fin_plan_pvt.lock_unlock_version
4951: (p_budget_version_id => l_curr_working_version_id,
4952: p_record_version_number => l_CW_record_version_number,
4953: p_action => 'U',
4954: p_user_id => l_user_id,

Line 5200: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

5196: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5197: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
5198: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5199:
5200: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
5201: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
5202:
5203: --Following parameters are needed for amounts check
5204: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;

Line 5913: PA_FIN_PLAN_PVT.lock_unlock_version

5909: --Lock the budget version before inserting a budget line
5910: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
5911: (p_budget_version_id => l_budget_version_id);
5912:
5913: PA_FIN_PLAN_PVT.lock_unlock_version
5914: ( p_budget_version_id => l_budget_version_id
5915: ,p_record_version_number => l_record_version_number
5916: ,p_action => 'L'
5917: ,p_user_id => FND_GLOBAL.User_id

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

5929: END IF;
5930: RAISE FND_API.G_EXC_ERROR;
5931: END IF;
5932:
5933: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of inserting
5934: --budget lines data in all relevant tables.
5935: PA_FIN_PLAN_PVT.add_fin_plan_lines
5936: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.
5937: ,p_fin_plan_version_id => l_budget_version_id

Line 5935: PA_FIN_PLAN_PVT.add_fin_plan_lines

5931: END IF;
5932:
5933: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of inserting
5934: --budget lines data in all relevant tables.
5935: PA_FIN_PLAN_PVT.add_fin_plan_lines
5936: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API--Bug 4224464.Changed this to AMG_API as this is a AMG flow.
5937: ,p_fin_plan_version_id => l_budget_version_id
5938: ,p_finplan_lines_tab => l_finplan_lines_tab
5939: ,x_return_status => p_return_status

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

5942:
5943: IF p_return_status <> FND_API.G_RET_STS_SUCCESS
5944: THEN
5945: IF(l_debug_mode='Y') THEN
5946: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';
5947: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
5948: END IF;
5949: RAISE FND_API.G_EXC_ERROR;
5950: END IF;

Line 5957: PA_FIN_PLAN_PVT.lock_unlock_version

5953: --unlock the budget version after inserting the budget line
5954: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
5955: (p_budget_version_id => l_budget_version_id);
5956:
5957: PA_FIN_PLAN_PVT.lock_unlock_version
5958: ( p_budget_version_id => l_budget_version_id
5959: ,p_record_version_number => l_record_version_number
5960: ,p_action => 'U'
5961: ,p_user_id => FND_GLOBAL.User_id

Line 6679: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

6675: ELSE -- Fin Plan Model
6676:
6677:
6678: -- validate the plan type passed
6679: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
6680: ( p_fin_plan_type_id => ll_fin_plan_type_id
6681: ,p_fin_plan_type_name => ll_fin_plan_type_name
6682: ,x_fin_plan_type_id => l_fin_plan_type_id
6683: ,x_return_status => p_return_status

Line 6885: pa_fin_plan_pvt.lock_unlock_version

6881:
6882: --Lock the version before deleting it
6883: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
6884: (p_budget_version_id => l_budget_version_id);
6885: pa_fin_plan_pvt.lock_unlock_version
6886: ( p_budget_version_id => l_budget_version_id
6887: ,p_record_version_number => l_record_version_number
6888: ,p_action => 'L'
6889: ,p_user_id => l_user_id

Line 7118: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

7114: -- FND_API.compatible_api_call
7115: -- PA_PROJECT_PVT.convert_pm_projref_to_id
7116: -- PA_PM_FUNCTION_SECURITY_PUB.check_budget_security
7117: -- PA_BUDGET_UTILS.delete_draft
7118: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
7119: -- PA_FIN_PLAN_UTILS.get_version_type
7120: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
7121: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number
7122: -- PA_FIN_PLAN_PVT.lock_unlock_version

Line 7122: -- PA_FIN_PLAN_PVT.lock_unlock_version

7118: -- PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
7119: -- PA_FIN_PLAN_UTILS.get_version_type
7120: -- PA_FIN_PLAN_UTILS.is_orgforecast_plan
7121: -- PA_FIN_PLAN_UTILS.retrieve_record_version_number
7122: -- PA_FIN_PLAN_PVT.lock_unlock_version
7123: -- PA_FIN_PLAN_PUB.delete_version
7124: --
7125: --History:
7126: -- 05-APR-2005 Rishukla Created.

Line 7696: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

7692:
7693: ELSE --finplan model
7694:
7695: --validate the plan type passed
7696: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
7697: ( p_fin_plan_type_id => l_fin_plan_type_id
7698: ,p_fin_plan_type_name => l_fin_plan_type_name
7699: ,x_fin_plan_type_id => ll_fin_plan_type_id
7700: ,x_return_status => p_return_status

Line 8904: PA_FIN_PLAN_PVT.lock_unlock_version

8900: --Lock the budget version before deleting a budget line
8901: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
8902: (p_budget_version_id => l_budget_version_id);
8903:
8904: PA_FIN_PLAN_PVT.lock_unlock_version
8905: ( p_budget_version_id => l_budget_version_id
8906: ,p_record_version_number => l_record_version_number
8907: ,p_action => 'L'
8908: ,p_user_id => FND_GLOBAL.User_id

Line 8974: PA_FIN_PLAN_PVT.lock_unlock_version

8970: --unlock the budget version after deleting the budget line
8971: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
8972: (p_budget_version_id => l_budget_version_id);
8973:
8974: PA_FIN_PLAN_PVT.lock_unlock_version
8975: ( p_budget_version_id => l_budget_version_id
8976: ,p_record_version_number => l_record_version_number
8977: ,p_action => 'U'
8978: ,p_user_id => FND_GLOBAL.User_id

Line 9508: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

9504: l_debug_level5 CONSTANT NUMBER :=5;
9505: l_baselined_Ver_options_id VARCHAR2(15);
9506: l_budget_lines_in budget_line_in_tbl_type;
9507: l_debug_level3 CONSTANT NUMBER := 3;
9508: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
9509: l_uncategorized_res_list_id pa_resource_list_members.resource_list_id%TYPE;
9510: l_unit_of_measure pa_resources.unit_of_measure%TYPE;
9511: l_unc_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
9512: l_unc_unit_of_measure pa_resources.unit_of_measure%TYPE;

Line 9891: pa_fin_plan_pvt.lock_unlock_version

9887: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
9888: (p_budget_version_id => l_budget_version_id);
9889:
9890: --Try to lock the version before updating the version. This is required so that nobody else can access it.
9891: pa_fin_plan_pvt.lock_unlock_version
9892: (p_budget_version_id => l_budget_version_id,
9893: p_record_version_number => l_record_version_number,
9894: p_action => 'L',
9895: p_user_id => l_user_id,

Line 10491: pa_fin_plan_pvt.lock_unlock_version

10487:
10488: --Get the record version number of the version to be updated
10489: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_budget_version_id);
10490:
10491: pa_fin_plan_pvt.lock_unlock_version
10492: (p_budget_version_id => l_CW_version_id,
10493: p_record_version_number => l_CW_record_version_number,
10494: p_action => 'L',
10495: p_user_id => l_user_id,

Line 12607: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES

12603: IF ( nvl(l_finplan_lines_tab.last,0) > 0 ) THEN
12604:
12605: -- dbms_output.put_line ('Calling add_finplan_lines');
12606:
12607: PA_FIN_PLAN_PVT.ADD_FIN_PLAN_LINES
12608: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API /* Bug# 2674353 */
12609: ,p_fin_plan_version_id => l_budget_version_id
12610: ,p_finplan_lines_tab => l_finplan_lines_tab
12611: ,x_return_status => l_return_status

Line 12632: pa_fin_plan_pvt.lock_unlock_version

12628: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
12629: (p_budget_version_id => l_budget_version_id);
12630:
12631: --Try to lock the version before updating the version. This is required so that nobody else can access it.
12632: pa_fin_plan_pvt.lock_unlock_version
12633: (p_budget_version_id => l_budget_version_id,
12634: p_record_version_number => l_record_version_number,
12635: p_action => 'U',
12636: p_user_id => l_user_id,

Line 13277: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;

13273: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13274: l_etc_method_code_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
13275: l_spread_curve_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
13276:
13277: l_finplan_lines_tab pa_fin_plan_pvt.budget_lines_tab;
13278: l_version_info_rec pa_fp_gen_amount_utils.fp_cols;
13279:
13280: --Following parameters are needed for amounts check
13281: l_amount_set_id NUMBER;

Line 14084: PA_FIN_PLAN_PVT.lock_unlock_version

14080: --Lock the budget version before updating a budget line
14081: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
14082: (p_budget_version_id => l_budget_version_id);
14083:
14084: PA_FIN_PLAN_PVT.lock_unlock_version
14085: ( p_budget_version_id => l_budget_version_id
14086: ,p_record_version_number => l_record_version_number
14087: ,p_action => 'L'
14088: ,p_user_id => FND_GLOBAL.User_id

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

14100: END IF;
14101: RAISE FND_API.G_EXC_ERROR;
14102: END IF;
14103:
14104: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of updating
14105: --budget lines data in all relevant tables.
14106: PA_FIN_PLAN_PVT.add_fin_plan_lines
14107: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API
14108: ,p_fin_plan_version_id => l_budget_version_id

Line 14106: PA_FIN_PLAN_PVT.add_fin_plan_lines

14102: END IF;
14103:
14104: --Call PA_FIN_PLAN_PVT.add_fin_plan_lines. This api takes care of updating
14105: --budget lines data in all relevant tables.
14106: PA_FIN_PLAN_PVT.add_fin_plan_lines
14107: ( p_calling_context => PA_FP_CONSTANTS_PKG.G_AMG_API
14108: ,p_fin_plan_version_id => l_budget_version_id
14109: ,p_finplan_lines_tab => l_finplan_lines_tab
14110: ,x_return_status => p_return_status

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

14113:
14114: IF p_return_status <> FND_API.G_RET_STS_SUCCESS
14115: THEN
14116: IF(l_debug_mode='Y') THEN
14117: pa_debug.g_err_stage := 'PA_FIN_PLAN_PVT.add_fin_plan_lines API falied';
14118: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
14119: END IF;
14120: RAISE FND_API.G_EXC_ERROR;
14121: END IF;

Line 14128: PA_FIN_PLAN_PVT.lock_unlock_version

14124: --unlock the budget version after updating the budget line
14125: l_record_version_number := PA_FIN_PLAN_UTILS.retrieve_record_version_number
14126: (p_budget_version_id => l_budget_version_id);
14127:
14128: PA_FIN_PLAN_PVT.lock_unlock_version
14129: ( p_budget_version_id => l_budget_version_id
14130: ,p_record_version_number => l_record_version_number
14131: ,p_action => 'U'
14132: ,p_user_id => FND_GLOBAL.User_id

Line 15171: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id

15167: -- Change the p_fin_plan_type_id, p_fin_plan_type_name to
15168: -- ll_fin_plan_type_id,ll_fin_plan_type_name
15169: -- Xin Liu. 28-APR-03
15170:
15171: PA_FIN_PLAN_PVT.convert_plan_type_name_to_id
15172: ( p_fin_plan_type_id => ll_fin_plan_type_id
15173: ,p_fin_plan_type_name => ll_fin_plan_type_name
15174: ,x_fin_plan_type_id => l_fin_plan_type_id
15175: ,x_return_status => p_return_status

Line 15691: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION

15687: -- Fetch the record version number of the plan version
15688: l_record_version_number :=
15689: PA_FIN_PLAN_UTILS.RETRIEVE_RECORD_VERSION_NUMBER(l_budget_version_id);
15690:
15691: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION
15692: ( p_budget_version_id => l_budget_version_id
15693: ,p_record_version_number => l_record_version_number
15694: ,p_action => 'L'
15695: ,p_user_id => FND_GLOBAL.User_id

Line 16758: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION

16754: -- Fetch the record version number of the plan version
16755: l_record_version_number :=
16756: PA_FIN_PLAN_UTILS.RETRIEVE_RECORD_VERSION_NUMBER(l_budget_version_id);
16757:
16758: PA_FIN_PLAN_PVT.LOCK_UNLOCK_VERSION
16759: ( p_budget_version_id => l_budget_version_id
16760: ,p_record_version_number => l_record_version_number
16761: ,p_action => 'U'
16762: ,p_user_id => FND_GLOBAL.User_id

Line 17950: pa_fin_plan_pvt.lock_unlock_version

17946:
17947: l_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number
17948: (p_budget_version_id => l_curr_work_version_id);
17949: l_user_id := FND_GLOBAL.User_id;
17950: pa_fin_plan_pvt.lock_unlock_version
17951: (p_budget_version_id => l_curr_work_version_id,
17952: p_record_version_number => l_record_version_number,
17953: p_action => 'L',
17954: p_user_id => l_user_id,

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

18810: (p_user_id => l_user_id,
18811: x_person_id => t_person_id,
18812: x_resource_id => t_resource_id,
18813: x_resource_name => t_resource_name);
18814: --dbms_output.put_line('pa_fin_plan_pvt.lock_unlock_version');
18815: pa_fin_plan_pvt.lock_unlock_version
18816: (p_budget_version_id => l_CW_version_id,
18817: p_record_version_number => l_CW_record_version_number,
18818: p_action => 'L',

Line 18815: pa_fin_plan_pvt.lock_unlock_version

18811: x_person_id => t_person_id,
18812: x_resource_id => t_resource_id,
18813: x_resource_name => t_resource_name);
18814: --dbms_output.put_line('pa_fin_plan_pvt.lock_unlock_version');
18815: pa_fin_plan_pvt.lock_unlock_version
18816: (p_budget_version_id => l_CW_version_id,
18817: p_record_version_number => l_CW_record_version_number,
18818: p_action => 'L',
18819: p_user_id => l_user_id,