APPS.IGS_AS_GEN_007 dependencies on IGS_TR_ITEM

Line 61: v_tracking_id igs_tr_item.tracking_id%TYPE;

57: v_check CHAR;
58: v_message_name VARCHAR2 (30);
59: e_resource_busy EXCEPTION;
60: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
61: v_tracking_id igs_tr_item.tracking_id%TYPE;
62: v_tri_start_dt igs_tr_item.start_dt%TYPE;
63: v_tri_business_days_ind igs_tr_item.business_days_ind%TYPE;
64: v_tsdv_action_dt igs_tr_step_v.action_dt%TYPE;
65: v_target_days NUMBER (3);

Line 62: v_tri_start_dt igs_tr_item.start_dt%TYPE;

58: v_message_name VARCHAR2 (30);
59: e_resource_busy EXCEPTION;
60: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
61: v_tracking_id igs_tr_item.tracking_id%TYPE;
62: v_tri_start_dt igs_tr_item.start_dt%TYPE;
63: v_tri_business_days_ind igs_tr_item.business_days_ind%TYPE;
64: v_tsdv_action_dt igs_tr_step_v.action_dt%TYPE;
65: v_target_days NUMBER (3);
66: v_other_detail VARCHAR2 (255);

Line 63: v_tri_business_days_ind igs_tr_item.business_days_ind%TYPE;

59: e_resource_busy EXCEPTION;
60: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
61: v_tracking_id igs_tr_item.tracking_id%TYPE;
62: v_tri_start_dt igs_tr_item.start_dt%TYPE;
63: v_tri_business_days_ind igs_tr_item.business_days_ind%TYPE;
64: v_tsdv_action_dt igs_tr_step_v.action_dt%TYPE;
65: v_target_days NUMBER (3);
66: v_other_detail VARCHAR2 (255);
67: cst_enrolled CONSTANT VARCHAR2 (10) := 'ENROLLED';

Line 181: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

177: AND creation_dt = cp_creation_dt
178: AND KEY = cp_key
179: AND text = cp_text;
180: --
181: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
182: SELECT start_dt,
183: business_days_ind
184: FROM igs_tr_item
185: WHERE tracking_id = cp_tracking_id;

Line 184: FROM igs_tr_item

180: --
181: CURSOR c_tri (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
182: SELECT start_dt,
183: business_days_ind
184: FROM igs_tr_item
185: WHERE tracking_id = cp_tracking_id;
186: --
187: CURSOR c_tsdv (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
188: SELECT MAX (action_dt)

Line 187: CURSOR c_tsdv (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

183: business_days_ind
184: FROM igs_tr_item
185: WHERE tracking_id = cp_tracking_id;
186: --
187: CURSOR c_tsdv (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
188: SELECT MAX (action_dt)
189: FROM igs_tr_step_v
190: WHERE tracking_id = cp_tracking_id;
191: --

Line 192: CURSOR c_tri_upd (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

188: SELECT MAX (action_dt)
189: FROM igs_tr_step_v
190: WHERE tracking_id = cp_tracking_id;
191: --
192: CURSOR c_tri_upd (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
193: SELECT ROWID,
194: igs_tr_item.*
195: FROM igs_tr_item
196: WHERE tracking_id = v_tracking_id

Line 194: igs_tr_item.*

190: WHERE tracking_id = cp_tracking_id;
191: --
192: CURSOR c_tri_upd (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
193: SELECT ROWID,
194: igs_tr_item.*
195: FROM igs_tr_item
196: WHERE tracking_id = v_tracking_id
197: FOR UPDATE OF business_days_ind NOWAIT;
198: --

Line 195: FROM igs_tr_item

191: --
192: CURSOR c_tri_upd (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
193: SELECT ROWID,
194: igs_tr_item.*
195: FROM igs_tr_item
196: WHERE tracking_id = v_tracking_id
197: FOR UPDATE OF business_days_ind NOWAIT;
198: --
199: v_tri_upd_rec c_tri_upd%ROWTYPE;

Line 525: igs_tr_item_pkg.update_row (

521: igs_tr_gen_001.trkp_clc_days_ovrdue (v_tri_start_dt, v_tsdv_action_dt, v_tri_business_days_ind);
522: OPEN c_tri_upd (v_tracking_id);
523: FETCH c_tri_upd INTO v_tri_upd_rec;
524: IF c_tri_upd%FOUND THEN
525: igs_tr_item_pkg.update_row (
526: x_rowid => v_tri_upd_rec.ROWID,
527: x_tracking_id => v_tri_upd_rec.tracking_id,
528: x_tracking_status => v_tri_upd_rec.tracking_status,
529: x_tracking_type => v_tri_upd_rec.tracking_type,