APPS.IGS_TR_GEN_002 dependencies on IGS_TR_ITEM_NOTE

Line 199: FROM igs_tr_item_note

195: DECLARE
196:
197: CURSOR c_del_tin IS
198: SELECT ROWID, reference_number
199: FROM igs_tr_item_note
200: WHERE tracking_id = lp_tracking_id
201: FOR UPDATE OF tracking_id NOWAIT;
202:
203: BEGIN

Line 206: igs_tr_item_note_pkg.delete_row( x_rowid => v_tin_rec.ROWID);

202:
203: BEGIN
204:
205: FOR v_tin_rec IN c_del_tin LOOP
206: igs_tr_item_note_pkg.delete_row( x_rowid => v_tin_rec.ROWID);
207: IF igs_ge_gen_001.genp_del_note( v_tin_rec.reference_number, v_message_name) = FALSE THEN
208: p_message_name := v_message_name;
209: EXIT;
210: END IF;

Line 223: p_message_name := 'IGS_TR_ITEM_NOTE_REC_LOCKED';

219:
220: EXCEPTION
221:
222: WHEN e_resource_busy THEN
223: p_message_name := 'IGS_TR_ITEM_NOTE_REC_LOCKED';
224: RETURN FALSE;
225:
226: WHEN OTHERS THEN
227: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');