APPS.IGS_TR_GEN_001 dependencies on IGS_TR_ITEM

Line 12: v_start_dt igs_tr_item.start_dt%TYPE;

8: p_sequence_ind IN VARCHAR2 DEFAULT 'N',
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)

Line 18: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%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
18: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
19: l_completion_due_dt igs_tr_item_all.completion_due_dt%TYPE ;
20: BEGIN
21:
22: DECLARE

Line 19: l_completion_due_dt igs_tr_item_all.completion_due_dt%TYPE ;

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
18: l_override_offset_clc_ind igs_tr_item_all.override_offset_clc_ind%TYPE ;
19: l_completion_due_dt igs_tr_item_all.completion_due_dt%TYPE ;
20: BEGIN
21:
22: DECLARE
23:

Line 39: FROM igs_tr_item

35: AND ts.tracking_step_number = cp_tracking_step_number;
36: --added for tracking dld - nov 2001
37: CURSOR c_tracking_item IS
38: SELECT NVL(override_offset_clc_ind , 'N'), completion_due_dt
39: FROM igs_tr_item
40: WHERE tracking_id = p_tracking_id ;
41:
42: BEGIN
43: OPEN c_tracking_item ;