DBA Data[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on FND_GLOBAL

Line 175: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

171: l_msg_data VARCHAR2(250) ;
172: l_data VARCHAR2(250) ;
173: l_msg_index_out NUMBER ;
174: l_error_msg_code VARCHAR2(250) ;
175: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
176: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
177: g1_debug_mode VARCHAR2(1) ;
178:
179: CURSOR check_pub_str

Line 176: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

172: l_data VARCHAR2(250) ;
173: l_msg_index_out NUMBER ;
174: l_error_msg_code VARCHAR2(250) ;
175: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
176: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
177: g1_debug_mode VARCHAR2(1) ;
178:
179: CURSOR check_pub_str
180: IS

Line 631: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

627: l_msg_data VARCHAR2(250) ;
628: l_data VARCHAR2(250) ;
629: l_msg_index_out NUMBER ;
630: l_error_msg_code VARCHAR2(250) ;
631: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
632: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
633: g1_debug_mode VARCHAR2(1) ;
634:
635: /*4275236 : Some Perf Enhancements*/

Line 632: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

628: l_data VARCHAR2(250) ;
629: l_msg_index_out NUMBER ;
630: l_error_msg_code VARCHAR2(250) ;
631: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
632: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
633: g1_debug_mode VARCHAR2(1) ;
634:
635: /*4275236 : Some Perf Enhancements*/
636: l_yes FND_LOOKUPS.MEANING%TYPE;

Line 5178: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

5174: l_msg_data VARCHAR2(250) ;
5175: l_data VARCHAR2(250) ;
5176: l_msg_index_out NUMBER ;
5177: l_error_msg_code VARCHAR2(250) ;
5178: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5179: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5180: g1_debug_mode VARCHAR2(1) ;
5181:
5182: /*4275236: Perf Enhancements*/

Line 5179: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

5175: l_data VARCHAR2(250) ;
5176: l_msg_index_out NUMBER ;
5177: l_error_msg_code VARCHAR2(250) ;
5178: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5179: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5180: g1_debug_mode VARCHAR2(1) ;
5181:
5182: /*4275236: Perf Enhancements*/
5183: l_yes FND_LOOKUPS.MEANING%TYPE;

Line 7786: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

7782: l_msg_data VARCHAR2(250) ;
7783: l_data VARCHAR2(250) ;
7784: l_msg_index_out NUMBER ;
7785: l_error_msg_code VARCHAR2(250) ;
7786: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
7787: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
7788: g1_debug_mode VARCHAR2(1) ;
7789:
7790: cursor get_structures IS

Line 7787: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

7783: l_data VARCHAR2(250) ;
7784: l_msg_index_out NUMBER ;
7785: l_error_msg_code VARCHAR2(250) ;
7786: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
7787: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
7788: g1_debug_mode VARCHAR2(1) ;
7789:
7790: cursor get_structures IS
7791: select por1.object_id_to1, por1.object_id_to2

Line 9771: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

9767: l_msg_data VARCHAR2(250) ;
9768: l_data VARCHAR2(250) ;
9769: l_msg_index_out NUMBER ;
9770: l_error_msg_code VARCHAR2(250) ;
9771: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9772: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9773: g1_debug_mode VARCHAR2(1) ;
9774:
9775: -- Bug Fix 5609629.

Line 9772: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

9768: l_data VARCHAR2(250) ;
9769: l_msg_index_out NUMBER ;
9770: l_error_msg_code VARCHAR2(250) ;
9771: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
9772: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
9773: g1_debug_mode VARCHAR2(1) ;
9774:
9775: -- Bug Fix 5609629.
9776: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call

Line 10531: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

10527: l_msg_data VARCHAR2(250) ;
10528: l_data VARCHAR2(250) ;
10529: l_msg_index_out NUMBER ;
10530: l_error_msg_code VARCHAR2(250) ;
10531: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
10532: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
10533: g1_debug_mode VARCHAR2(1) ;
10534:
10535: -- Bug Fix 5609629.

Line 10532: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

10528: l_data VARCHAR2(250) ;
10529: l_msg_index_out NUMBER ;
10530: l_error_msg_code VARCHAR2(250) ;
10531: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
10532: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
10533: g1_debug_mode VARCHAR2(1) ;
10534:
10535: -- Bug Fix 5609629.
10536: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call

Line 11290: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

11286: l_msg_data VARCHAR2(250) ;
11287: l_data VARCHAR2(250) ;
11288: l_msg_index_out NUMBER ;
11289: l_error_msg_code VARCHAR2(250) ;
11290: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
11291: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11292: g1_debug_mode VARCHAR2(1) ;
11293:
11294: -- Bug Fix 5611760. Performance changes.

Line 11291: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

11287: l_data VARCHAR2(250) ;
11288: l_msg_index_out NUMBER ;
11289: l_error_msg_code VARCHAR2(250) ;
11290: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
11291: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11292: g1_debug_mode VARCHAR2(1) ;
11293:
11294: -- Bug Fix 5611760. Performance changes.
11295: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

Line 13907: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

13903: l_msg_data VARCHAR2(250) ;
13904: l_data VARCHAR2(250) ;
13905: l_msg_index_out NUMBER ;
13906: l_error_msg_code VARCHAR2(250) ;
13907: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
13908: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
13909: g1_debug_mode VARCHAR2(1) ;
13910:
13911: -- Bug Fix 5611760. Performance changes.

Line 13908: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

13904: l_data VARCHAR2(250) ;
13905: l_msg_index_out NUMBER ;
13906: l_error_msg_code VARCHAR2(250) ;
13907: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
13908: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
13909: g1_debug_mode VARCHAR2(1) ;
13910:
13911: -- Bug Fix 5611760. Performance changes.
13912: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

Line 16434: l_user_id NUMBER := FND_GLOBAL.USER_ID;

16430: ,x_msg_data OUT NOCOPY VARCHAR2)
16431: is
16432: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
16433: l_api_version CONSTANT NUMBER := p_api_version;
16434: l_user_id NUMBER := FND_GLOBAL.USER_ID;
16435: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
16436: l_return_status VARCHAR2(1);
16437: l_msg_count NUMBER;
16438: l_msg_data VARCHAR2(250);

Line 16435: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

16431: is
16432: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
16433: l_api_version CONSTANT NUMBER := p_api_version;
16434: l_user_id NUMBER := FND_GLOBAL.USER_ID;
16435: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
16436: l_return_status VARCHAR2(1);
16437: l_msg_count NUMBER;
16438: l_msg_data VARCHAR2(250);
16439: l_baselined_str_ver_id NUMBER; -- FPM Dev CR 7