DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on FND_GLOBAL

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

12: --Added by rtarway for FP.M Mapping
13: G_PROJECT_SHARING_TYPE VARCHAR2(250);
14: --Added by rtarway for FP.M Mapping
15: --PACKAGE GLOBAL to be used during updates -------------------------------------------
16: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
17: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
18:
19: l_pm_product_code VARCHAR2(30) := 'Z'; /*for bug 2413400 a new variable defined.*/
20: /* increased the lenght for bug 2665656 */

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

13: G_PROJECT_SHARING_TYPE VARCHAR2(250);
14: --Added by rtarway for FP.M Mapping
15: --PACKAGE GLOBAL to be used during updates -------------------------------------------
16: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
17: G_LOGIN_ID CONSTANT NUMBER := FND_GLOBAL.login_id;
18:
19: l_pm_product_code VARCHAR2(30) := 'Z'; /*for bug 2413400 a new variable defined.*/
20: /* increased the lenght for bug 2665656 */
21:

Line 727: l_resp_id := FND_GLOBAL.Resp_id;

723:
724: END IF;
725:
726:
727: l_resp_id := FND_GLOBAL.Resp_id;
728:
729:
730: --Bug#5559292
731:

Line 4045: ,fnd_global.user_id

4041: ,l_allow_inv_rate_type_fg
4042: ,l_bill_another_prj_flag
4043: ,l_receiver_task_id
4044: ,l_def_tt_cust_flag --Bug 3279981
4045: ,fnd_global.user_id
4046: ,fnd_global.login_id
4047: ,l_err_code
4048: ,l_err_stage
4049: ,l_err_stack );

Line 4046: ,fnd_global.login_id

4042: ,l_bill_another_prj_flag
4043: ,l_receiver_task_id
4044: ,l_def_tt_cust_flag --Bug 3279981
4045: ,fnd_global.user_id
4046: ,fnd_global.login_id
4047: ,l_err_code
4048: ,l_err_stage
4049: ,l_err_stack );
4050: ----dbms_output.put_line('After Calling create_customer_contacts l_err_code'||l_err_code);

Line 5465: p_user_id => FND_GLOBAL.USER_ID,

5461:
5462: -- Bug 7335526
5463: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5464: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5465: p_user_id => FND_GLOBAL.USER_ID,
5466: p_unique_number => to_number(l_project_number_out));
5467: END IF;
5468:
5469: --4218977, rtarway, unset this global variable upon unsuccessfull completion of create project

Line 5491: p_user_id => FND_GLOBAL.USER_ID,

5487:
5488: -- Bug 7335526
5489: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5490: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5491: p_user_id => FND_GLOBAL.USER_ID,
5492: p_unique_number => to_number(l_project_number_out));
5493: END IF;
5494:
5495: --4218977, rtarway, unset this global variable upon unsuccessfull completion of create project

Line 5517: p_user_id => FND_GLOBAL.USER_ID,

5513:
5514: -- Bug 7335526
5515: IF G_PROJECT_NUMBER_GEN_MODE = 'AUTOMATIC' THEN
5516: PA_UTILS_SQNUM_PKG.revert_unique_proj_num(p_table_name => 'PA_PROJECTS',
5517: p_user_id => FND_GLOBAL.USER_ID,
5518: p_unique_number => to_number(l_project_number_out));
5519: END IF;
5520:
5521: --4218977, rtarway, unset this global variable upon unsuccessfull completion of create project

Line 6036: l_resp_id := FND_GLOBAL.Resp_id;

6032: END IF;
6033:
6034: end if;
6035:
6036: l_resp_id := FND_GLOBAL.Resp_id;
6037: l_user_id := FND_GLOBAL.User_id;
6038: --l_module_name := p_pm_product_code||'.'||'PA_PM_ADD_TASK';
6039: l_module_name := 'PA_PM_ADD_TASK';
6040:

Line 6037: l_user_id := FND_GLOBAL.User_id;

6033:
6034: end if;
6035:
6036: l_resp_id := FND_GLOBAL.Resp_id;
6037: l_user_id := FND_GLOBAL.User_id;
6038: --l_module_name := p_pm_product_code||'.'||'PA_PM_ADD_TASK';
6039: l_module_name := 'PA_PM_ADD_TASK';
6040:
6041: --Moved from below for bug 2471668

Line 10968: l_prev_locked_status := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id);

10964: --bug 4538849
10965:
10966: -- Begin Bug # 4582750.
10967:
10968: l_prev_locked_status := PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id);
10969:
10970: if ( l_prev_locked_status = 'O' ) then
10971:
10972: -- End Bug # 4582750.

Line 11085: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then

11081: ELSIF (struct_ver_updatable = 'Y') THEN
11082: -- structure version is locked by another user check must be done in both update modes. bug 4519809
11083: --IF (p_update_mode = 'PA_UPD_TASK_ATTR') THEN --bug 4534919
11084: --Check if str version is locked by another user
11085: if ( PA_PROJECT_STRUCTURE_UTILS.IS_STRUC_VER_LOCKED_BY_USER(FND_GLOBAL.USER_ID,l_structure_version_id) = 'O' ) then
11086: --if yes, raise error.
11087: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
11088: p_msg_name => 'PA_STR_LOCKED_BY_OTHER');
11089: RAISE FND_API.G_EXC_ERROR;

Line 11199: l_resp_id := FND_GLOBAL.Resp_id;

11195: RAISE FND_API.G_EXC_ERROR;
11196: END IF;
11197: END IF; --bug 2841158
11198:
11199: l_resp_id := FND_GLOBAL.Resp_id;
11200: l_user_id := FND_GLOBAL.User_id;
11201: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_PROJECT';
11202: l_module_name := 'PA_PM_UPDATE_PROJECT';
11203:

Line 11200: l_user_id := FND_GLOBAL.User_id;

11196: END IF;
11197: END IF; --bug 2841158
11198:
11199: l_resp_id := FND_GLOBAL.Resp_id;
11200: l_user_id := FND_GLOBAL.User_id;
11201: --l_module_name := p_pm_product_code||'.'||'PA_PM_UPDATE_PROJECT';
11202: l_module_name := 'PA_PM_UPDATE_PROJECT';
11203:
11204: --bug 2665656

Line 11862: ,X_entered_by_user_id => FND_GLOBAL.USER_ID

11858: ,X_task_manager_person_id => NULL
11859: ,X_Service_type => NULL
11860: ,X_task_start_date => NULL
11861: ,X_task_end_date => NULL
11862: ,X_entered_by_user_id => FND_GLOBAL.USER_ID
11863: ,X_attribute_category => l_project_rec.attribute_category
11864: ,X_attribute1 => l_project_rec.attribute1
11865: ,X_attribute2 => l_project_rec.attribute2
11866: ,X_attribute3 => l_project_rec.attribute3

Line 20597: X_User => FND_GLOBAL.USER_ID,

20593: X_Inv_Exchange_Rate => l_INV_EXCHANGE_RATE, --bug 5554475
20594: X_Allow_Inv_Rate_Type_Fg => l_ALLOW_INV_USER_RATE_FLAG, --bug 5554475
20595: X_Bill_Another_Project_Fg => l_bill_another_project_flag, -- Added for 4153629
20596: X_Receiver_Task_Id => l_receiver_task_id , -- Added for 4153629
20597: X_User => FND_GLOBAL.USER_ID,
20598: X_Login => FND_GLOBAL.LOGIN_ID,
20599: X_Err_Code => l_err_code,
20600: X_Err_Stage => l_err_stage,
20601: X_Err_Stack => l_err_stack

Line 20598: X_Login => FND_GLOBAL.LOGIN_ID,

20594: X_Allow_Inv_Rate_Type_Fg => l_ALLOW_INV_USER_RATE_FLAG, --bug 5554475
20595: X_Bill_Another_Project_Fg => l_bill_another_project_flag, -- Added for 4153629
20596: X_Receiver_Task_Id => l_receiver_task_id , -- Added for 4153629
20597: X_User => FND_GLOBAL.USER_ID,
20598: X_Login => FND_GLOBAL.LOGIN_ID,
20599: X_Err_Code => l_err_code,
20600: X_Err_Stage => l_err_stage,
20601: X_Err_Stack => l_err_stack
20602: );

Line 21196: X_User => FND_GLOBAL.USER_ID,

21192: X_Inv_Exchange_Rate => l_INV_EXCHANGE_RATE, --bug 5554475
21193: X_Allow_Inv_Rate_Type_Fg => l_ALLOW_INV_USER_RATE_FLAG, --bug 5554475
21194: X_Bill_Another_Project_Fg => l_bill_another_project_flag ,-- Added for 4153629,
21195: X_Receiver_Task_Id => l_receiver_task_id, --Added for 4153629
21196: X_User => FND_GLOBAL.USER_ID,
21197: X_Login => FND_GLOBAL.LOGIN_ID,
21198: X_Err_Code => l_err_code,
21199: X_Err_Stage => l_err_stage,
21200: X_Err_Stack => l_err_stack

Line 21197: X_Login => FND_GLOBAL.LOGIN_ID,

21193: X_Allow_Inv_Rate_Type_Fg => l_ALLOW_INV_USER_RATE_FLAG, --bug 5554475
21194: X_Bill_Another_Project_Fg => l_bill_another_project_flag ,-- Added for 4153629,
21195: X_Receiver_Task_Id => l_receiver_task_id, --Added for 4153629
21196: X_User => FND_GLOBAL.USER_ID,
21197: X_Login => FND_GLOBAL.LOGIN_ID,
21198: X_Err_Code => l_err_code,
21199: X_Err_Stage => l_err_stage,
21200: X_Err_Stack => l_err_stack
21201: );

Line 21670: X_LAST_UPDATED_BY => fnd_global.user_id,

21666: X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
21667: X_OLD_PROJECT_STATUS_CODE => l_project_rec.project_status_code,
21668: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
21669: X_CHANGE_COMMENT => p_project_in.status_change_comment,
21670: X_LAST_UPDATED_BY => fnd_global.user_id,
21671: X_CREATED_BY => fnd_global.user_id,
21672: X_CREATION_DATE => sysdate,
21673: X_LAST_UPDATE_DATE => sysdate,
21674: X_LAST_UPDATE_LOGIN => fnd_global.user_id );

Line 21671: X_CREATED_BY => fnd_global.user_id,

21667: X_OLD_PROJECT_STATUS_CODE => l_project_rec.project_status_code,
21668: X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
21669: X_CHANGE_COMMENT => p_project_in.status_change_comment,
21670: X_LAST_UPDATED_BY => fnd_global.user_id,
21671: X_CREATED_BY => fnd_global.user_id,
21672: X_CREATION_DATE => sysdate,
21673: X_LAST_UPDATE_DATE => sysdate,
21674: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
21675:

Line 21674: X_LAST_UPDATE_LOGIN => fnd_global.user_id );

21670: X_LAST_UPDATED_BY => fnd_global.user_id,
21671: X_CREATED_BY => fnd_global.user_id,
21672: X_CREATION_DATE => sysdate,
21673: X_LAST_UPDATE_DATE => sysdate,
21674: X_LAST_UPDATE_LOGIN => fnd_global.user_id );
21675:
21676: IF (l_debug_mode = 'Y') THEN
21677: pa_debug.debug(' Updated PA_PROJECTS_ALL for status history');
21678: END IF;

Line 29057: l_user_id NUMBER := FND_GLOBAL.USER_ID;

29053:
29054: IS
29055: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
29056: l_api_version CONSTANT NUMBER := p_api_version;
29057: l_user_id NUMBER := FND_GLOBAL.USER_ID;
29058: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
29059: l_return_status VARCHAR2(1);
29060: l_msg_count NUMBER;
29061: l_msg_data VARCHAR2(250);

Line 29058: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

29054: IS
29055: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_LP_PROG_ON_CWV';
29056: l_api_version CONSTANT NUMBER := p_api_version;
29057: l_user_id NUMBER := FND_GLOBAL.USER_ID;
29058: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
29059: l_return_status VARCHAR2(1);
29060: l_msg_count NUMBER;
29061: l_msg_data VARCHAR2(250);
29062:

Line 29064: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

29060: l_msg_count NUMBER;
29061: l_msg_data VARCHAR2(250);
29062:
29063: l_function_allowed VARCHAR2(1);
29064: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
29065: l_debug_mode VARCHAR2(1);
29066:
29067: l_project_id NUMBER;
29068:

Line 30114: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

30110:
30111: i NUMBER := 0;
30112: i_actn NUMBER := 0;
30113:
30114: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
30115: l_function_allowed VARCHAR2(1);
30116: l_pm_product_code VARCHAR2(2) :='Z'; /* Bug 3651113 */
30117:
30118: -- 3651542 added local variable

Line 30784: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

30780: l_err_message VARCHAR2(2000);
30781: l_unique_flag VARCHAR2(1);
30782:
30783: l_function_allowed VARCHAR2(1);
30784: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
30785:
30786: l_deliverable_id NUMBER := 0;
30787:
30788: i NUMBER := 1;

Line 31265: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

31261: i_actn_ins NUMBER := 0;
31262: i_actn_upd NUMBER := 0;
31263:
31264: l_function_allowed VARCHAR2(1);
31265: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
31266: l_pm_product_code VARCHAR2(2) :='Z'; /* Bug 3651113 */
31267:
31268: /*cursor added for Bug 3651113 */
31269: Cursor p_product_code_csr (p_pm_product_code IN VARCHAR2)

Line 31872: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

31868:
31869: l_project_id NUMBER := null;
31870: l_deliverable_id NUMBER := null;
31871: l_function_allowed VARCHAR2(1);
31872: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
31873:
31874: -- 3729250 added local variables
31875: l_fin_task_id NUMBER := NULL;
31876: l_action_id NUMBER := NULL;

Line 32229: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

32225: l_deliverable_id NUMBER;
32226: l_dlvr_version_id NUMBER;
32227: l_project_id NUMBER;
32228: l_function_allowed VARCHAR2(1);
32229: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32230:
32231: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32232: l_msg_index_out NUMBER;
32233: l_msg_count NUMBER ;

Line 32496: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

32492: l_dlvr_version_id NUMBER;
32493: l_function_code Pa_Proj_Elements.function_code%TYPE;
32494:
32495: l_function_allowed VARCHAR2(1);
32496: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32497:
32498: l_msg_index_out NUMBER;
32499: l_msg_count NUMBER ;
32500: l_data VARCHAR2(2000);

Line 32795: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

32791: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
32792: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
32793:
32794: l_function_allowed VARCHAR2(1);
32795: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
32796:
32797: l_msg_index_out NUMBER;
32798: l_msg_count NUMBER ;
32799: l_data VARCHAR2(2000);

Line 33082: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

33078: l_function_code Pa_Proj_Elements.function_code%TYPE;
33079: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33080:
33081: l_function_allowed VARCHAR2(1);
33082: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
33083:
33084: l_msg_index_out NUMBER;
33085: l_msg_count NUMBER ;
33086: l_data VARCHAR2(2000);

Line 33371: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

33367: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33368: l_task_assignment_id NUMBER ;
33369:
33370: l_function_allowed VARCHAR2(1);
33371: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
33372:
33373: l_msg_index_out NUMBER;
33374: l_msg_count NUMBER ;
33375: l_data VARCHAR2(2000);

Line 33650: l_resp_id NUMBER := FND_GLOBAL.Resp_id;

33646: l_object_relationship_Id pa_object_relationships.object_relationship_Id%TYPE;
33647: l_task_assignment_id NUMBER ;
33648:
33649: l_function_allowed VARCHAR2(1);
33650: l_resp_id NUMBER := FND_GLOBAL.Resp_id;
33651:
33652: l_msg_index_out NUMBER;
33653: l_msg_count NUMBER ;
33654: l_data VARCHAR2(2000);

Line 36462: l_responsibility_id := FND_GLOBAL.Resp_id;

36458:
36459: RAISE FND_API.G_EXC_ERROR;
36460: End If;
36461:
36462: l_responsibility_id := FND_GLOBAL.Resp_id;
36463: l_user_id := FND_GLOBAL.User_id;
36464:
36465:
36466: -- As part of enforcing project security, which would determine

Line 36463: l_user_id := FND_GLOBAL.User_id;

36459: RAISE FND_API.G_EXC_ERROR;
36460: End If;
36461:
36462: l_responsibility_id := FND_GLOBAL.Resp_id;
36463: l_user_id := FND_GLOBAL.User_id;
36464:
36465:
36466: -- As part of enforcing project security, which would determine
36467: -- whether the user has the necessary privileges to update the project

Line 36908: , p_responsibility_id => FND_GLOBAL.RESP_ID

36904: -- will error out as the user does not have access.
36905:
36906: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
36907: (p_api_version_number => p_api_version
36908: , p_responsibility_id => FND_GLOBAL.RESP_ID
36909: , p_function_name => 'PA_PM_UPDATE_PROJECT'
36910: , p_msg_count => l_msg_count
36911: , p_msg_data => l_msg_data
36912: , p_return_status => l_return_status

Line 37326: , p_responsibility_id => FND_GLOBAL.RESP_ID

37322: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
37323: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37324: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37325: (p_api_version_number => p_api_version
37326: , p_responsibility_id => FND_GLOBAL.RESP_ID
37327: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'
37328: , p_msg_count => l_msg_count
37329: , p_msg_data => l_msg_data
37330: , p_return_status => l_return_status

Line 37362: , p_responsibility_id => FND_GLOBAL.RESP_ID

37358: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
37359: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37360: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37361: (p_api_version_number => p_api_version
37362: , p_responsibility_id => FND_GLOBAL.RESP_ID
37363: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'
37364: , p_msg_count => l_msg_count
37365: , p_msg_data => l_msg_data
37366: , p_return_status => l_return_status

Line 37942: , p_responsibility_id => FND_GLOBAL.RESP_ID

37938: if (p_program_links_tbl(l_count).structure_type = 'WORKPLAN'
37939: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37940: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37941: (p_api_version_number => p_api_version
37942: , p_responsibility_id => FND_GLOBAL.RESP_ID
37943: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'
37944: , p_msg_count => l_msg_count
37945: , p_msg_data => l_msg_data
37946: , p_return_status => l_return_status

Line 37979: , p_responsibility_id => FND_GLOBAL.RESP_ID

37975: if (p_program_links_tbl(l_count).structure_type = 'FINANCIAL'
37976: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
37977: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
37978: (p_api_version_number => p_api_version
37979: , p_responsibility_id => FND_GLOBAL.RESP_ID
37980: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'
37981: , p_msg_count => l_msg_count
37982: , p_msg_data => l_msg_data
37983: , p_return_status => l_return_status

Line 38467: , p_responsibility_id => FND_GLOBAL.RESP_ID

38463: if (p_structure_type = 'WORKPLAN'
38464: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
38465: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
38466: (p_api_version_number => p_api_version
38467: , p_responsibility_id => FND_GLOBAL.RESP_ID
38468: , p_function_name => 'PA_PAXPREPR_WP_LINK_PROJ'
38469: , p_msg_count => l_msg_count
38470: , p_msg_data => l_msg_data
38471: , p_return_status => l_return_status

Line 38499: , p_responsibility_id => FND_GLOBAL.RESP_ID

38495: if (p_structure_type = 'FINANCIAL'
38496: or PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(l_parent_project_id) = 'Y') then
38497: PA_PM_FUNCTION_SECURITY_PUB.check_function_security
38498: (p_api_version_number => p_api_version
38499: , p_responsibility_id => FND_GLOBAL.RESP_ID
38500: , p_function_name => 'PA_PAXPREPR_OPT_SUBPROJECTS'
38501: , p_msg_count => l_msg_count
38502: , p_msg_data => l_msg_data
38503: , p_return_status => l_return_status

Line 40767: l_user_id := fnd_global.user_id;

40763: END IF; -- src_wbs_level = 1
40764: END IF; -- l_display_sequence_tab(j) > src_seq_number
40765: END IF; -- l_element_version_id_tab(j) = src_elem_ver_id
40766: END LOOP;
40767: l_user_id := fnd_global.user_id;
40768: l_login_id := fnd_global.login_id;
40769:
40770: -- Locking should be implemnted here
40771:

Line 40768: l_login_id := fnd_global.login_id;

40764: END IF; -- l_display_sequence_tab(j) > src_seq_number
40765: END IF; -- l_element_version_id_tab(j) = src_elem_ver_id
40766: END LOOP;
40767: l_user_id := fnd_global.user_id;
40768: l_login_id := fnd_global.login_id;
40769:
40770: -- Locking should be implemnted here
40771:
40772: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST

Line 42208: l_user_id := fnd_global.user_id;

42204: END IF;
42205: END LOOP;
42206:
42207:
42208: l_user_id := fnd_global.user_id;
42209: l_login_id := fnd_global.login_id;
42210:
42211: -- Locking should be implemented here
42212:

Line 42209: l_login_id := fnd_global.login_id;

42205: END LOOP;
42206:
42207:
42208: l_user_id := fnd_global.user_id;
42209: l_login_id := fnd_global.login_id;
42210:
42211: -- Locking should be implemented here
42212:
42213: FORALL j IN l_element_version_id_tab.FIRST..l_element_version_id_tab.LAST