APPS.IGS_TR_GEN_001 dependencies on IGS_TR_STEP

Line 13: v_action_days igs_tr_step.action_days%TYPE;

9: p_business_days_ind IN VARCHAR2 DEFAULT 'N')
10: RETURN DATE IS
11: gv_other_detail VARCHAR2(255);
12: v_start_dt igs_tr_item.start_dt%TYPE;
13: v_action_days igs_tr_step.action_days%TYPE;
14: v_action_dt DATE;
15: v_prev_completion_dt DATE;
16: -- new variables added during tracking dld for nov 2001 release bug(1837257)
17: -- added a new cursor to get the override offset indicator value for the item

Line 24: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS

20: BEGIN
21:
22: DECLARE
23:
24: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
25: SELECT ts.action_days, ts.completion_dt, ts.by_pass_ind
26: FROM igs_tr_step ts
27: WHERE ts.tracking_id = cp_tracking_id
28: AND ts.tracking_step_number <= cp_tracking_step_number

Line 26: FROM igs_tr_step ts

22: DECLARE
23:
24: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
25: SELECT ts.action_days, ts.completion_dt, ts.by_pass_ind
26: FROM igs_tr_step ts
27: WHERE ts.tracking_id = cp_tracking_id
28: AND ts.tracking_step_number <= cp_tracking_step_number
29: ORDER BY ts.tracking_step_number;
30:

Line 31: CURSOR c_tracking_step_1( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS

27: WHERE ts.tracking_id = cp_tracking_id
28: AND ts.tracking_step_number <= cp_tracking_step_number
29: ORDER BY ts.tracking_step_number;
30:
31: CURSOR c_tracking_step_1( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
32: SELECT ts.action_days
33: FROM igs_tr_step ts
34: WHERE ts.tracking_id = cp_tracking_id
35: AND ts.tracking_step_number = cp_tracking_step_number;

Line 33: FROM igs_tr_step ts

29: ORDER BY ts.tracking_step_number;
30:
31: CURSOR c_tracking_step_1( cp_tracking_id igs_tr_step.tracking_id%TYPE, cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
32: SELECT ts.action_days
33: FROM igs_tr_step ts
34: WHERE ts.tracking_id = cp_tracking_id
35: AND ts.tracking_step_number = cp_tracking_step_number;
36: --added for tracking dld - nov 2001
37: CURSOR c_tracking_item IS

Line 152: v_completion_dt igs_tr_step.completion_dt%TYPE;

148:
149: BEGIN
150:
151: DECLARE
152: v_completion_dt igs_tr_step.completion_dt%TYPE;
153: v_ovrdue_days NUMBER;
154: v_message_name VARCHAR2(30);
155:
156: BEGIN

Line 273: v_completion_dt igs_tr_step.completion_dt%TYPE;

269: BEGIN
270:
271: DECLARE
272: cst_active VARCHAR2(6) := 'ACTIVE';
273: v_completion_dt igs_tr_step.completion_dt%TYPE;
274: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE) IS
275: SELECT MAX(ts.completion_dt)
276: FROM igs_tr_step ts
277: WHERE ts.tracking_id = cp_tracking_id;

Line 274: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE) IS

270:
271: DECLARE
272: cst_active VARCHAR2(6) := 'ACTIVE';
273: v_completion_dt igs_tr_step.completion_dt%TYPE;
274: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE) IS
275: SELECT MAX(ts.completion_dt)
276: FROM igs_tr_step ts
277: WHERE ts.tracking_id = cp_tracking_id;
278:

Line 276: FROM igs_tr_step ts

272: cst_active VARCHAR2(6) := 'ACTIVE';
273: v_completion_dt igs_tr_step.completion_dt%TYPE;
274: CURSOR c_tracking_step( cp_tracking_id igs_tr_step.tracking_id%TYPE) IS
275: SELECT MAX(ts.completion_dt)
276: FROM igs_tr_step ts
277: WHERE ts.tracking_id = cp_tracking_id;
278:
279: BEGIN
280: