DBA Data[Home] [Help]

APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on FND_USER

Line 137: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;

133: function Get_eMAIL_Address(
134: p_user_name IN varchar2
135: ) return varchar2
136: IS
137: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
138: v_SQL varchar2(500);
139: CURSOR C IS
140: SELECT email_address
141: FROM fnd_user

Line 141: FROM fnd_user

137: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
138: v_SQL varchar2(500);
139: CURSOR C IS
140: SELECT email_address
141: FROM fnd_user
142: WHERE user_name = p_user_name;
143:
144: v_Users C%ROWTYPE;
145: begin

Line 164: l_user_id FND_USER.USER_ID%TYPE;

160: function Get_User_ID(
161: user_name IN varchar2
162: ) return number
163: IS
164: l_user_id FND_USER.USER_ID%TYPE;
165: v_SQL1 varchar2(500);
166: begin
167: v_SQL1 := 'select user_id from fnd_user' ||
168: ' where user_name = :name';

Line 167: v_SQL1 := 'select user_id from fnd_user' ||

163: IS
164: l_user_id FND_USER.USER_ID%TYPE;
165: v_SQL1 varchar2(500);
166: begin
167: v_SQL1 := 'select user_id from fnd_user' ||
168: ' where user_name = :name';
169: EXECUTE IMMEDIATE v_SQL1 INTO l_user_id USING user_name;
170: return l_user_id;
171: end Get_User_ID;

Line 353: from fnd_user

349: IS
350: v_SQL1 varchar2(500);
351: cursor user_id_cursor is
352: select user_id
353: from fnd_user
354: where user_name = p_user_name;
355: return_value boolean;
356: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
357: BEGIN