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 3367: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

3363: l_msg_data VARCHAR2(250) ;
3364: l_data VARCHAR2(250) ;
3365: l_msg_index_out NUMBER ;
3366: l_error_msg_code VARCHAR2(250) ;
3367: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
3368: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
3369: g1_debug_mode VARCHAR2(1) ;
3370:
3371: /*4275236: Perf Enhancements*/

Line 3368: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

3364: l_data VARCHAR2(250) ;
3365: l_msg_index_out NUMBER ;
3366: l_error_msg_code VARCHAR2(250) ;
3367: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
3368: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
3369: g1_debug_mode VARCHAR2(1) ;
3370:
3371: /*4275236: Perf Enhancements*/
3372: l_yes FND_LOOKUPS.MEANING%TYPE;

Line 5972: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

5968: l_msg_data VARCHAR2(250) ;
5969: l_data VARCHAR2(250) ;
5970: l_msg_index_out NUMBER ;
5971: l_error_msg_code VARCHAR2(250) ;
5972: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5973: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5974: g1_debug_mode VARCHAR2(1) ;
5975:
5976: cursor get_structures IS

Line 5973: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

5969: l_data VARCHAR2(250) ;
5970: l_msg_index_out NUMBER ;
5971: l_error_msg_code VARCHAR2(250) ;
5972: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
5973: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
5974: g1_debug_mode VARCHAR2(1) ;
5975:
5976: cursor get_structures IS
5977: select por1.object_id_to1, por1.object_id_to2

Line 7441: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

7437: l_msg_data VARCHAR2(250) ;
7438: l_data VARCHAR2(250) ;
7439: l_msg_index_out NUMBER ;
7440: l_error_msg_code VARCHAR2(250) ;
7441: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
7442: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
7443: g1_debug_mode VARCHAR2(1) ;
7444:
7445: -- Bug Fix 5609629.

Line 7442: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

7438: l_data VARCHAR2(250) ;
7439: l_msg_index_out NUMBER ;
7440: l_error_msg_code VARCHAR2(250) ;
7441: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
7442: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
7443: g1_debug_mode VARCHAR2(1) ;
7444:
7445: -- Bug Fix 5609629.
7446: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call

Line 8201: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

8197: l_msg_data VARCHAR2(250) ;
8198: l_data VARCHAR2(250) ;
8199: l_msg_index_out NUMBER ;
8200: l_error_msg_code VARCHAR2(250) ;
8201: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8202: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8203: g1_debug_mode VARCHAR2(1) ;
8204:
8205: -- Bug Fix 5609629.

Line 8202: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

8198: l_data VARCHAR2(250) ;
8199: l_msg_index_out NUMBER ;
8200: l_error_msg_code VARCHAR2(250) ;
8201: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8202: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8203: g1_debug_mode VARCHAR2(1) ;
8204:
8205: -- Bug Fix 5609629.
8206: -- Caching the wp_version_enable_flag in a local variable in order to avoid the function call

Line 8960: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

8956: l_msg_data VARCHAR2(250) ;
8957: l_data VARCHAR2(250) ;
8958: l_msg_index_out NUMBER ;
8959: l_error_msg_code VARCHAR2(250) ;
8960: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8961: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8962: g1_debug_mode VARCHAR2(1) ;
8963:
8964: -- Bug Fix 5611760. Performance changes.

Line 8961: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

8957: l_data VARCHAR2(250) ;
8958: l_msg_index_out NUMBER ;
8959: l_error_msg_code VARCHAR2(250) ;
8960: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
8961: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
8962: g1_debug_mode VARCHAR2(1) ;
8963:
8964: -- Bug Fix 5611760. Performance changes.
8965: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

Line 11574: l_user_id NUMBER := FND_GLOBAL.USER_ID ;

11570: l_msg_data VARCHAR2(250) ;
11571: l_data VARCHAR2(250) ;
11572: l_msg_index_out NUMBER ;
11573: l_error_msg_code VARCHAR2(250) ;
11574: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
11575: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11576: g1_debug_mode VARCHAR2(1) ;
11577:
11578: -- Bug Fix 5611760. Performance changes.

Line 11575: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;

11571: l_data VARCHAR2(250) ;
11572: l_msg_index_out NUMBER ;
11573: l_error_msg_code VARCHAR2(250) ;
11574: l_user_id NUMBER := FND_GLOBAL.USER_ID ;
11575: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID ;
11576: g1_debug_mode VARCHAR2(1) ;
11577:
11578: -- Bug Fix 5611760. Performance changes.
11579: -- obtaining the task_weight_basis_code from the pa_proj_progress_attr table

Line 14098: l_user_id NUMBER := FND_GLOBAL.USER_ID;

14094: ,x_msg_data OUT NOCOPY VARCHAR2)
14095: is
14096: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
14097: l_api_version CONSTANT NUMBER := p_api_version;
14098: l_user_id NUMBER := FND_GLOBAL.USER_ID;
14099: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
14100: l_return_status VARCHAR2(1);
14101: l_msg_count NUMBER;
14102: l_msg_data VARCHAR2(250);

Line 14099: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

14095: is
14096: l_api_name CONSTANT VARCHAR2(30) := 'populate_pji_tab_for_plan';
14097: l_api_version CONSTANT NUMBER := p_api_version;
14098: l_user_id NUMBER := FND_GLOBAL.USER_ID;
14099: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
14100: l_return_status VARCHAR2(1);
14101: l_msg_count NUMBER;
14102: l_msg_data VARCHAR2(250);
14103: l_baselined_str_ver_id NUMBER; -- FPM Dev CR 7