APPS.IGS_EN_GEN_018 dependencies on FND_GLOBAL

Line 124: last_updated_by=fnd_global.user_id, last_update_login=fnd_global.login_id, last_update_date=SYSDATE,

120:
121: UPDATE igs_en_blk_sua_ints
122: SET ERROR_TXT=l_message,
123: status_flag=DECODE(p_level,'E','E','W1',status_flag,'S'), -- W1 is grp level warning..changing to S here will prevent c_bulk_suas from picking this upload
124: last_updated_by=fnd_global.user_id, last_update_login=fnd_global.login_id, last_update_date=SYSDATE,
125: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,
126: program_application_id=fnd_global.prog_appl_id, program_update_date=SYSDATE
127: WHERE batch_id=p_batch_id
128: AND status_flag IN ('U','R','S')

Line 125: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,

121: UPDATE igs_en_blk_sua_ints
122: SET ERROR_TXT=l_message,
123: status_flag=DECODE(p_level,'E','E','W1',status_flag,'S'), -- W1 is grp level warning..changing to S here will prevent c_bulk_suas from picking this upload
124: last_updated_by=fnd_global.user_id, last_update_login=fnd_global.login_id, last_update_date=SYSDATE,
125: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,
126: program_application_id=fnd_global.prog_appl_id, program_update_date=SYSDATE
127: WHERE batch_id=p_batch_id
128: AND status_flag IN ('U','R','S')
129: AND person_number =p_person_number

Line 126: program_application_id=fnd_global.prog_appl_id, program_update_date=SYSDATE

122: SET ERROR_TXT=l_message,
123: status_flag=DECODE(p_level,'E','E','W1',status_flag,'S'), -- W1 is grp level warning..changing to S here will prevent c_bulk_suas from picking this upload
124: last_updated_by=fnd_global.user_id, last_update_login=fnd_global.login_id, last_update_date=SYSDATE,
125: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,
126: program_application_id=fnd_global.prog_appl_id, program_update_date=SYSDATE
127: WHERE batch_id=p_batch_id
128: AND status_flag IN ('U','R','S')
129: AND person_number =p_person_number
130: AND program_cd = NVL(p_program_cd ,program_cd)

Line 209: last_updated_by = fnd_global.user_id, last_update_login =fnd_global.login_id,last_update_date=SYSDATE,

205: END IF;
206: END IF;
207: l_message:=enrpl_get_msg(l_message_table(i).message);
208: UPDATE igs_en_blk_sua_ints SET ERROR_TXT=l_message , STATUS_FLAG=l_message_table(i).type,
209: last_updated_by = fnd_global.user_id, last_update_login =fnd_global.login_id,last_update_date=SYSDATE,
210: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,program_application_id=fnd_global.prog_appl_id,
211: program_update_date=SYSDATE
212: WHERE upload_id=l_message_table(i).upload_id;
213:

Line 210: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,program_application_id=fnd_global.prog_appl_id,

206: END IF;
207: l_message:=enrpl_get_msg(l_message_table(i).message);
208: UPDATE igs_en_blk_sua_ints SET ERROR_TXT=l_message , STATUS_FLAG=l_message_table(i).type,
209: last_updated_by = fnd_global.user_id, last_update_login =fnd_global.login_id,last_update_date=SYSDATE,
210: request_id=fnd_global.conc_request_id, program_id=fnd_global.conc_program_id ,program_application_id=fnd_global.prog_appl_id,
211: program_update_date=SYSDATE
212: WHERE upload_id=l_message_table(i).upload_id;
213:
214: l_fcount:=1;l_lcount:=1;