APPS.IGS_TR_GEN_002 dependencies on IGS_TR_GROUP

Line 155: SELECT ROWID,igs_tr_group_member.*

151:
152: DECLARE
153:
154: CURSOR c_del_tgm IS
155: SELECT ROWID,igs_tr_group_member.*
156: FROM igs_tr_group_member
157: WHERE tracking_id = p_tracking_id
158: FOR UPDATE OF tracking_id NOWAIT;
159:

Line 156: FROM igs_tr_group_member

152: DECLARE
153:
154: CURSOR c_del_tgm IS
155: SELECT ROWID,igs_tr_group_member.*
156: FROM igs_tr_group_member
157: WHERE tracking_id = p_tracking_id
158: FOR UPDATE OF tracking_id NOWAIT;
159:
160: BEGIN

Line 163: igs_tr_group_member_pkg.delete_row( x_rowid => v_tgm_rec.ROWID);

159:
160: BEGIN
161:
162: FOR v_tgm_rec IN c_del_tgm LOOP
163: igs_tr_group_member_pkg.delete_row( x_rowid => v_tgm_rec.ROWID);
164: END LOOP;
165:
166: RETURN TRUE;
167: END;

Line 400: CURSOR c_tracking_group_member ( cp_tracking_group_id igs_tr_group.tracking_group_id%TYPE) IS

396: v_active_flag BOOLEAN DEFAULT FALSE;
397: v_cancelled_cnt NUMBER(3) DEFAULT 0;
398: v_row_cnt NUMBER(3) DEFAULT 0;
399:
400: CURSOR c_tracking_group_member ( cp_tracking_group_id igs_tr_group.tracking_group_id%TYPE) IS
401: SELECT tracking_id
402: FROM igs_tr_group_member
403: WHERE tracking_group_id = cp_tracking_group_id;
404:

Line 402: FROM igs_tr_group_member

398: v_row_cnt NUMBER(3) DEFAULT 0;
399:
400: CURSOR c_tracking_group_member ( cp_tracking_group_id igs_tr_group.tracking_group_id%TYPE) IS
401: SELECT tracking_id
402: FROM igs_tr_group_member
403: WHERE tracking_group_id = cp_tracking_group_id;
404:
405: BEGIN
406: