APPS.IGR_GEN_002 dependencies on FND_GLOBAL

Line 34: WHERE created_by = FND_GLOBAL.USER_ID;

30:
31: CURSOR cur_max_batch_id IS
32: SELECT MAX(batch_id)
33: FROM igs_ad_imp_batch_det
34: WHERE created_by = FND_GLOBAL.USER_ID;
35: l_max_batch_id NUMBER;
36:
37: CURSOR cur_chk_batch (cp_batch_id igs_ad_interface_ctl.batch_id%TYPE) IS
38: SELECT batch_id

Line 82: l_user_id NUMBER := FND_GLOBAL.USER_ID;

78: FROM dual;
79: l_imp_batch_id NUMBER;
80:
81: l_batch_desc VARCHAR2(2000);
82: l_user_id NUMBER := FND_GLOBAL.USER_ID;
83:
84: -- Get the user name
85: CURSOR cur_user_name IS
86: SELECT SUBSTR(user_name,1,20)

Line 88: WHERE USER_ID = FND_GLOBAL.USER_ID;

84: -- Get the user name
85: CURSOR cur_user_name IS
86: SELECT SUBSTR(user_name,1,20)
87: FROM fnd_user
88: WHERE USER_ID = FND_GLOBAL.USER_ID;
89: l_user_name VARCHAR2(50);
90:
91: l_create_new_batch BOOLEAN := FALSE;
92: BEGIN

Line 124: fnd_global.user_id,

120: program_update_date,
121: program_id)
122: VALUES ( l_imp_batch_id,
123: l_batch_desc,
124: fnd_global.user_id,
125: SYSDATE,
126: fnd_global.user_id,
127: SYSDATE,
128: NULL,

Line 126: fnd_global.user_id,

122: VALUES ( l_imp_batch_id,
123: l_batch_desc,
124: fnd_global.user_id,
125: SYSDATE,
126: fnd_global.user_id,
127: SYSDATE,
128: NULL,
129: NULL,
130: NULL,