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 FND_GLOBAL

Line 5: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;

1: package body PA_BUDGET_PUB as
2: --$Header: PAPMBUPB.pls 120.37.12020000.7 2013/05/24 10:10:15 djambhek ship $
3:
4: --package global to be used during updates
5: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
6: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
7: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/
8:
9: -- Bug Fix: 4569365. Removed MRC code.

Line 6: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;

2: --$Header: PAPMBUPB.pls 120.37.12020000.7 2013/05/24 10:10:15 djambhek ship $
3:
4: --package global to be used during updates
5: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
6: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
7: l_pm_product_code VARCHAR2(2) :='Z'; /*for bug 2413400 a new variable defined.*/
8:
9: -- Bug Fix: 4569365. Removed MRC code.
10: -- g_mrc_exception EXCEPTION; /* FPB2 */

Line 496: l_user_id := FND_GLOBAL.User_id;

492: ELSE
493: l_project_id := p_pa_project_id;
494: END IF;
495: --Get the user id and responsibility Ids
496: l_user_id := FND_GLOBAL.User_id;
497: l_resp_id := FND_GLOBAL.Resp_id;
498:
499: -- This api will initialize the data that will be used by the map_new_amg_msg.
500: -- Commented out the procedure call as required by Venkatesh. 25-APR-03

Line 497: l_resp_id := FND_GLOBAL.Resp_id;

493: l_project_id := p_pa_project_id;
494: END IF;
495: --Get the user id and responsibility Ids
496: l_user_id := FND_GLOBAL.User_id;
497: l_resp_id := FND_GLOBAL.Resp_id;
498:
499: -- This api will initialize the data that will be used by the map_new_amg_msg.
500: -- Commented out the procedure call as required by Venkatesh. 25-APR-03
501: /*

Line 3527: l_user_id := FND_GLOBAL.User_id;

3523:
3524: END IF;
3525:
3526: --Get the user id and responsibility Ids
3527: l_user_id := FND_GLOBAL.User_id;
3528: l_resp_id := FND_GLOBAL.Resp_id;
3529:
3530:
3531: -- This api will initialize the data that will be used by the map_new_amg_msg.

Line 3528: l_resp_id := FND_GLOBAL.Resp_id;

3524: END IF;
3525:
3526: --Get the user id and responsibility Ids
3527: l_user_id := FND_GLOBAL.User_id;
3528: l_resp_id := FND_GLOBAL.Resp_id;
3529:
3530:
3531: -- This api will initialize the data that will be used by the map_new_amg_msg.
3532: -- commented out the procedure call as required by venkatesh. 25-APR-03

Line 5917: ,p_user_id => FND_GLOBAL.User_id

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
5918: ,p_person_id => null
5919: ,x_return_status => p_return_status
5920: ,x_msg_count => p_msg_count
5921: ,x_msg_data => p_msg_data);

Line 5961: ,p_user_id => FND_GLOBAL.User_id

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
5962: ,p_person_id => null
5963: ,x_return_status => p_return_status
5964: ,x_msg_count => p_msg_count
5965: ,x_msg_data => p_msg_data);

Line 6283: l_resp_id := FND_GLOBAL.Resp_id;

6279: FND_MSG_PUB.initialize;
6280:
6281: END IF;
6282: -- This api will initialize the data that will be used by the map_new_amg_msg.
6283: l_resp_id := FND_GLOBAL.Resp_id;
6284: l_user_id := FND_GLOBAL.User_id;
6285:
6286: -- Added Logic by Xin Liu to handle MISS vars based on Manoj's code review.
6287: -- 28-APR-03

Line 6284: l_user_id := FND_GLOBAL.User_id;

6280:
6281: END IF;
6282: -- This api will initialize the data that will be used by the map_new_amg_msg.
6283: l_resp_id := FND_GLOBAL.Resp_id;
6284: l_user_id := FND_GLOBAL.User_id;
6285:
6286: -- Added Logic by Xin Liu to handle MISS vars based on Manoj's code review.
6287: -- 28-APR-03
6288: IF p_fin_plan_type_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM THEN

Line 6947: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6943: UPDATE pa_proj_fp_options
6944: SET gen_src_cost_plan_version_id = NULL,
6945: record_version_number = record_version_number + 1,
6946: last_update_date = SYSDATE,
6947: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6948: last_update_login = FND_GLOBAL.LOGIN_ID
6949: WHERE project_id = l_project_id
6950: AND gen_src_cost_plan_version_id = l_budget_version_id;
6951: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

Line 6948: last_update_login = FND_GLOBAL.LOGIN_ID

6944: SET gen_src_cost_plan_version_id = NULL,
6945: record_version_number = record_version_number + 1,
6946: last_update_date = SYSDATE,
6947: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6948: last_update_login = FND_GLOBAL.LOGIN_ID
6949: WHERE project_id = l_project_id
6950: AND gen_src_cost_plan_version_id = l_budget_version_id;
6951: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
6952: THEN

Line 6957: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6953: UPDATE pa_proj_fp_options
6954: SET gen_src_rev_plan_version_id = NULL,
6955: record_version_number = record_version_number + 1,
6956: last_update_date = SYSDATE,
6957: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6958: last_update_login = FND_GLOBAL.LOGIN_ID
6959: WHERE project_id = l_project_id
6960: AND gen_src_rev_plan_version_id = l_budget_version_id;
6961: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

Line 6958: last_update_login = FND_GLOBAL.LOGIN_ID

6954: SET gen_src_rev_plan_version_id = NULL,
6955: record_version_number = record_version_number + 1,
6956: last_update_date = SYSDATE,
6957: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6958: last_update_login = FND_GLOBAL.LOGIN_ID
6959: WHERE project_id = l_project_id
6960: AND gen_src_rev_plan_version_id = l_budget_version_id;
6961: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
6962: THEN

Line 6967: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6963: UPDATE pa_proj_fp_options
6964: SET gen_src_all_plan_version_id = NULL,
6965: record_version_number = record_version_number + 1,
6966: last_update_date = SYSDATE,
6967: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6968: last_update_login = FND_GLOBAL.LOGIN_ID
6969: WHERE project_id = l_project_id
6970: AND gen_src_all_plan_version_id = l_budget_version_id;
6971: END IF;

Line 6968: last_update_login = FND_GLOBAL.LOGIN_ID

6964: SET gen_src_all_plan_version_id = NULL,
6965: record_version_number = record_version_number + 1,
6966: last_update_date = SYSDATE,
6967: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6968: last_update_login = FND_GLOBAL.LOGIN_ID
6969: WHERE project_id = l_project_id
6970: AND gen_src_all_plan_version_id = l_budget_version_id;
6971: END IF;
6972:

Line 6980: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

6976: IF SQL%ROWCOUNT > 0 THEN
6977: UPDATE pa_budget_versions
6978: SET record_version_number = record_version_number + 1,
6979: last_update_date = SYSDATE,
6980: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6981: last_update_login = FND_GLOBAL.LOGIN_ID
6982: WHERE project_id = l_project_id
6983: AND budget_version_id = l_budget_version_id;
6984: END IF;

Line 6981: last_update_login = FND_GLOBAL.LOGIN_ID

6977: UPDATE pa_budget_versions
6978: SET record_version_number = record_version_number + 1,
6979: last_update_date = SYSDATE,
6980: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
6981: last_update_login = FND_GLOBAL.LOGIN_ID
6982: WHERE project_id = l_project_id
6983: AND budget_version_id = l_budget_version_id;
6984: END IF;
6985:

Line 7860: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7856: UPDATE pa_proj_fp_options
7857: SET gen_src_cost_plan_version_id = NULL,
7858: record_version_number = record_version_number + 1,
7859: last_update_date = SYSDATE,
7860: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7861: last_update_login = FND_GLOBAL.LOGIN_ID
7862: WHERE project_id = l_project_id
7863: AND gen_src_cost_plan_version_id = l_budget_version_id;
7864: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE

Line 7861: last_update_login = FND_GLOBAL.LOGIN_ID

7857: SET gen_src_cost_plan_version_id = NULL,
7858: record_version_number = record_version_number + 1,
7859: last_update_date = SYSDATE,
7860: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7861: last_update_login = FND_GLOBAL.LOGIN_ID
7862: WHERE project_id = l_project_id
7863: AND gen_src_cost_plan_version_id = l_budget_version_id;
7864: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_REVENUE
7865: THEN

Line 7870: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7866: UPDATE pa_proj_fp_options
7867: SET gen_src_rev_plan_version_id = NULL,
7868: record_version_number = record_version_number + 1,
7869: last_update_date = SYSDATE,
7870: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7871: last_update_login = FND_GLOBAL.LOGIN_ID
7872: WHERE project_id = l_project_id
7873: AND gen_src_rev_plan_version_id = l_budget_version_id;
7874: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL

Line 7871: last_update_login = FND_GLOBAL.LOGIN_ID

7867: SET gen_src_rev_plan_version_id = NULL,
7868: record_version_number = record_version_number + 1,
7869: last_update_date = SYSDATE,
7870: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7871: last_update_login = FND_GLOBAL.LOGIN_ID
7872: WHERE project_id = l_project_id
7873: AND gen_src_rev_plan_version_id = l_budget_version_id;
7874: ELSIF l_version_type = PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL
7875: THEN

Line 7880: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7876: UPDATE pa_proj_fp_options
7877: SET gen_src_all_plan_version_id = NULL,
7878: record_version_number = record_version_number + 1,
7879: last_update_date = SYSDATE,
7880: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7881: last_update_login = FND_GLOBAL.LOGIN_ID
7882: WHERE project_id = l_project_id
7883: AND gen_src_all_plan_version_id = l_budget_version_id;
7884: END IF;

Line 7881: last_update_login = FND_GLOBAL.LOGIN_ID

7877: SET gen_src_all_plan_version_id = NULL,
7878: record_version_number = record_version_number + 1,
7879: last_update_date = SYSDATE,
7880: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7881: last_update_login = FND_GLOBAL.LOGIN_ID
7882: WHERE project_id = l_project_id
7883: AND gen_src_all_plan_version_id = l_budget_version_id;
7884: END IF;
7885:

Line 7893: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),

7889: IF SQL%ROWCOUNT > 0 THEN
7890: UPDATE pa_budget_versions
7891: SET record_version_number = record_version_number + 1,
7892: last_update_date = SYSDATE,
7893: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7894: last_update_login = FND_GLOBAL.LOGIN_ID
7895: WHERE project_id = l_project_id
7896: AND budget_version_id = l_budget_version_id;
7897: END IF;

Line 7894: last_update_login = FND_GLOBAL.LOGIN_ID

7890: UPDATE pa_budget_versions
7891: SET record_version_number = record_version_number + 1,
7892: last_update_date = SYSDATE,
7893: last_updated_by = to_number(nvl(fnd_profile.value('USER_ID'),fnd_global.user_id)),
7894: last_update_login = FND_GLOBAL.LOGIN_ID
7895: WHERE project_id = l_project_id
7896: AND budget_version_id = l_budget_version_id;
7897: END IF;
7898:

Line 8908: ,p_user_id => FND_GLOBAL.User_id

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
8909: ,p_person_id => null
8910: ,x_return_status => p_return_status
8911: ,x_msg_count => p_msg_count
8912: ,x_msg_data => p_msg_data);

Line 8978: ,p_user_id => FND_GLOBAL.User_id

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
8979: ,p_person_id => null
8980: ,x_return_status => p_return_status
8981: ,x_msg_count => p_msg_count
8982: ,x_msg_data => p_msg_data);

Line 9774: l_user_id := FND_GLOBAL.User_id;

9770: lx_burden_rate_flag := p_burden_rate_flag ;
9771: END IF;
9772: /*Checks End for Plan Amount Entry Flags for bug 6408139*/
9773:
9774: l_user_id := FND_GLOBAL.User_id;
9775:
9776: /* The G_MISS_XXX/null handling for these variables below has been deleted from the existing code in update_budget
9777: . This handling would be done in validate_header_info now */
9778: l_project_id := p_pa_project_id;

Line 14088: ,p_user_id => FND_GLOBAL.User_id

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
14089: ,p_person_id => null
14090: ,x_return_status => p_return_status
14091: ,x_msg_count => p_msg_count
14092: ,x_msg_data => p_msg_data);

Line 14132: ,p_user_id => FND_GLOBAL.User_id

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
14133: ,p_person_id => null
14134: ,x_return_status => p_return_status
14135: ,x_msg_count => p_msg_count
14136: ,x_msg_data => p_msg_data);

Line 14688: l_resp_id := FND_GLOBAL.Resp_id;

14684: p_return_status := FND_API.G_RET_STS_ERROR;
14685: RAISE FND_API.G_EXC_ERROR;
14686: END IF;
14687:
14688: l_resp_id := FND_GLOBAL.Resp_id;
14689: l_user_id := FND_GLOBAL.User_id;
14690: -- l_module_name := 'PA_FP_MAINTAIN_GENERATED_PLAN'; -- 'PA_PM_UPDATE_BUDGET_LINE';
14691:
14692: -- Bug 2863564

Line 14689: l_user_id := FND_GLOBAL.User_id;

14685: RAISE FND_API.G_EXC_ERROR;
14686: END IF;
14687:
14688: l_resp_id := FND_GLOBAL.Resp_id;
14689: l_user_id := FND_GLOBAL.User_id;
14690: -- l_module_name := 'PA_FP_MAINTAIN_GENERATED_PLAN'; -- 'PA_PM_UPDATE_BUDGET_LINE';
14691:
14692: -- Bug 2863564
14693: -- The code below commented out as all the security checks are shifted to a common API

Line 14696: l_resp_id := FND_GLOBAL.Resp_id;

14692: -- Bug 2863564
14693: -- The code below commented out as all the security checks are shifted to a common API
14694: /*
14695: IF p_update_db_flag = 'Y' THEN
14696: l_resp_id := FND_GLOBAL.Resp_id;
14697: l_user_id := FND_GLOBAL.User_id;
14698: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_BUDGET_LINE';
14699: l_module_name := 'PA_PM_UPDATE_BUDGET_LINE';
14700:

Line 14697: l_user_id := FND_GLOBAL.User_id;

14693: -- The code below commented out as all the security checks are shifted to a common API
14694: /*
14695: IF p_update_db_flag = 'Y' THEN
14696: l_resp_id := FND_GLOBAL.Resp_id;
14697: l_user_id := FND_GLOBAL.User_id;
14698: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_BUDGET_LINE';
14699: l_module_name := 'PA_PM_UPDATE_BUDGET_LINE';
14700:
14701: -- As part of enforcing project security, which would determine

Line 15695: ,p_user_id => FND_GLOBAL.User_id

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
15696: ,p_person_id => NULL
15697: ,x_return_status => p_return_status
15698: ,x_msg_count => p_msg_count
15699: ,x_msg_data => p_msg_data);

Line 16762: ,p_user_id => FND_GLOBAL.User_id

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
16763: ,p_person_id => NULL
16764: ,x_return_status => p_return_status
16765: ,x_msg_count => p_msg_count
16766: ,x_msg_data => p_msg_data);

Line 17872: l_user_id := FND_GLOBAL.User_id;

17868: END IF;
17869:
17870:
17871:
17872: l_user_id := FND_GLOBAL.User_id;
17873:
17874: pa_budget_pvt.Validate_Header_Info
17875: ( p_api_version_number => p_api_version_number
17876: ,p_budget_version_name => p_budget_version_name

Line 17949: l_user_id := FND_GLOBAL.User_id;

17945: IF nvl(p_replace_current_working_flag,'N')= 'Y' THEN
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',

Line 18808: l_user_id := FND_GLOBAL.User_id;

18804:
18805: l_CW_record_version_number := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_CW_version_id);
18806:
18807: l_created_ver_rec_ver_num := pa_fin_plan_utils.Retrieve_Record_Version_Number(l_created_version_id);
18808: l_user_id := FND_GLOBAL.User_id;
18809: PA_COMP_PROFILE_PUB.GET_USER_INFO
18810: (p_user_id => l_user_id,
18811: x_person_id => t_person_id,
18812: x_resource_id => t_resource_id,