APPS.IBU_DYN_USER_GROUPS_PKG dependencies on FND_GLOBAL

Line 4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

1: Package Body IBU_DYN_USER_GROUPS_PKG AS
2: /* $Header: ibudyugb.pls 120.3 2007/12/18 11:23:37 mpathani ship $ */
3: -- --------- ------ ------------------------------------------
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
6:
7: -- =================================================================================================================
8: Procedure Log_Message(p_Message IN VARCHAR2)

Line 5: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;

1: Package Body IBU_DYN_USER_GROUPS_PKG AS
2: /* $Header: ibudyugb.pls 120.3 2007/12/18 11:23:37 mpathani ship $ */
3: -- --------- ------ ------------------------------------------
4: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
5: G_LOGIN_ID NUMBER := FND_GLOBAL.LOGIN_ID;
6:
7: -- =================================================================================================================
8: Procedure Log_Message(p_Message IN VARCHAR2)
9: IS

Line 39: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

35: x_resource_id OUT NOCOPY jtf_rs_resource_extns.resource_id%TYPE,
36: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE
37: )
38: IS
39: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
40:
41: -- Temporary variables
42: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
43: l_creby_empid fnd_user.employee_id%TYPE;

Line 195: l_first_substring := l_first_substring || ' , ' || '''' || p_category || '''' || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' ' ;

191: --SELECT SUBSTR (l_q_str, l_num, l_length) INTO l_last_substring FROM DUAL;
192: -- For case sensitive queries
193: SELECT SUBSTR (p_sql_text, l_num, l_length) INTO l_last_substring FROM DUAL;
194:
195: l_first_substring := l_first_substring || ' , ' || '''' || p_category || '''' || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' , sysdate, ' || FND_GLOBAL.USER_ID || ' ' ;
196: l_q_str := l_first_substring || l_last_substring;
197: l_ins_qry := 'insert into ibu_usergroups_temp(source_id, category,creation_date, created_by, last_update_date, last_updated_by ) ';
198: l_ins_qry := l_ins_qry || l_q_str;
199: Log_Message(' Insert Temp table query = { ' || l_ins_qry || ' } ');

Line 1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

1109: l_role_relate_id jtf_rs_role_relations.role_relate_id%TYPE;
1110: l_object_version_number jtf_rs_role_relations.object_version_number%TYPE;
1111:
1112: -- constant
1113: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1114:
1115: l_res_end_date_active jtf_rs_resource_extns.end_date_active%TYPE;
1116: l_source_name jtf_rs_resource_extns.source_name%TYPE;
1117: l_address_id jtf_rs_resource_extns.address_id%TYPE;

Line 1234: l_current_user_id NUMBER := FND_GLOBAL.User_Id;

1230: x_resource_number OUT NOCOPY jtf_rs_resource_extns.resource_number%TYPE,
1231: x_setup_success OUT NOCOPY NUMBER
1232: )
1233: IS
1234: l_current_user_id NUMBER := FND_GLOBAL.User_Id;
1235:
1236: -- Temporary variables
1237: l_creby_source_id jtf_rs_resource_extns.source_id%TYPE;
1238: l_creby_empid fnd_user.employee_id%TYPE;