APPS.GL_CI_WORKFLOW_PKG dependencies on FND_USER

Line 104: v_user_name fnd_user.user_name%type;

100: l_sender_name VARCHAR2(30);
101: l_message_name varchar2(30);
102: l_send_from VARCHAR2(30);
103: v_SQL varchar2(500);
104: v_user_name fnd_user.user_name%type;
105: l_consolidation_id number;
106: l_consolidation_set_id number;
107: l_from_period_name varchar2(15);
108: l_to_period_name varchar2(15);

Line 212: v_SQL := 'select email_address from fnd_user@' || p_dblink || '.world' ||

208: l_send_to := NULL;
209: -- return;
210: END IF;
211: /***
212: v_SQL := 'select email_address from fnd_user@' || p_dblink || '.world' ||
213: ' where user_name = :name';
214: EXECUTE IMMEDIATE v_SQL INTO l_send_to USING v_user_name;
215: COMMIT;
216: ***/

Line 352: fnd_user_name fnd_user.user_name%type;

348: l_import_message_body IN VARCHAR2,
349: l_post_request_id IN varchar2
350: ) IS
351: l_user_id number;
352: fnd_user_name fnd_user.user_name%type;
353: Cursor f_user_name IS
354: SELECT user_name
355: FROM fnd_user
356: WHERE user_id = l_user_id;

Line 355: FROM fnd_user

351: l_user_id number;
352: fnd_user_name fnd_user.user_name%type;
353: Cursor f_user_name IS
354: SELECT user_name
355: FROM fnd_user
356: WHERE user_id = l_user_id;
357: l_monitor_url VARCHAR2(500);
358: Begin
359: --+ Set the process owner