eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_TR_VAL_TRST dependencies on IGS_TR_STEP

Line 36: CURSOR c_tracking_step_prev( cp_tracking_id igs_tr_step.tracking_id%TYPE,

32: WHERE tracking_id = cp_tracking_id;
33:
34: -- modified this cursor during tracking dld nov 2001 (bug 1837257)
35: --to include logic for step_group_id
36: CURSOR c_tracking_step_prev( cp_tracking_id igs_tr_step.tracking_id%TYPE,
37: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
38: SELECT distinct to_number('1')
39: FROM igs_tr_step trst
40: WHERE trst.tracking_id = cp_tracking_id

Line 37: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS

33:
34: -- modified this cursor during tracking dld nov 2001 (bug 1837257)
35: --to include logic for step_group_id
36: CURSOR c_tracking_step_prev( cp_tracking_id igs_tr_step.tracking_id%TYPE,
37: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
38: SELECT distinct to_number('1')
39: FROM igs_tr_step trst
40: WHERE trst.tracking_id = cp_tracking_id
41: AND trst.tracking_step_number < cp_tracking_step_number

Line 39: FROM igs_tr_step trst

35: --to include logic for step_group_id
36: CURSOR c_tracking_step_prev( cp_tracking_id igs_tr_step.tracking_id%TYPE,
37: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
38: SELECT distinct to_number('1')
39: FROM igs_tr_step trst
40: WHERE trst.tracking_id = cp_tracking_id
41: AND trst.tracking_step_number < cp_tracking_step_number
42: AND trst.step_group_id is null
43: AND trst.step_completion_ind = 'N'

Line 47: FROM igs_tr_step trst

43: AND trst.step_completion_ind = 'N'
44: AND trst.by_pass_ind = 'N'
45: UNION
46: (SELECT distinct trst.step_group_id
47: FROM igs_tr_step trst
48: WHERE trst.tracking_id = cp_tracking_id
49: AND trst.tracking_step_number < cp_tracking_step_number
50: AND trst.step_group_id is not null
51: AND trst.step_completion_ind = 'N'

Line 56: FROM igs_tr_step trst

52: AND trst.by_pass_ind = 'N'
53: GROUP BY trst.step_group_id , trst.step_completion_ind
54: MINUS
55: SELECT distinct trst.step_group_id
56: FROM igs_tr_step trst
57: WHERE trst.tracking_id = cp_tracking_id
58: AND trst.tracking_step_number < cp_tracking_step_number
59: AND trst.step_group_id is not null
60: AND trst.step_completion_ind = 'Y'

Line 67: CURSOR c_tracking_step_next( cp_tracking_id igs_tr_step.tracking_id%TYPE,

63:
64: -- added this cursor during tracking dld nov 2001 (bug 1837257)
65: --checks if any of the next steps are completed or can be treated as
66: --complete then this step completion_dt cannot be updated
67: CURSOR c_tracking_step_next( cp_tracking_id igs_tr_step.tracking_id%TYPE,
68: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
69: SELECT distinct to_number('1')
70: FROM igs_tr_step trst
71: WHERE trst.tracking_id = cp_tracking_id

Line 68: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS

64: -- added this cursor during tracking dld nov 2001 (bug 1837257)
65: --checks if any of the next steps are completed or can be treated as
66: --complete then this step completion_dt cannot be updated
67: CURSOR c_tracking_step_next( cp_tracking_id igs_tr_step.tracking_id%TYPE,
68: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
69: SELECT distinct to_number('1')
70: FROM igs_tr_step trst
71: WHERE trst.tracking_id = cp_tracking_id
72: AND trst.tracking_step_number > cp_tracking_step_number

Line 70: FROM igs_tr_step trst

66: --complete then this step completion_dt cannot be updated
67: CURSOR c_tracking_step_next( cp_tracking_id igs_tr_step.tracking_id%TYPE,
68: cp_tracking_step_number igs_tr_step.tracking_step_number%TYPE) IS
69: SELECT distinct to_number('1')
70: FROM igs_tr_step trst
71: WHERE trst.tracking_id = cp_tracking_id
72: AND trst.tracking_step_number > cp_tracking_step_number
73: AND trst.step_group_id is null
74: AND trst.step_completion_ind = 'Y'

Line 77: FROM igs_tr_step trst

73: AND trst.step_group_id is null
74: AND trst.step_completion_ind = 'Y'
75: MINUS
76: SELECT distinct to_number('1')
77: FROM igs_tr_step trst
78: WHERE trst.tracking_id = cp_tracking_id
79: AND trst.tracking_step_number = cp_tracking_step_number
80: AND trst.step_group_id is not null
81: AND trst.step_completion_ind = 'N'

Line 84: FROM igs_tr_step trst

80: AND trst.step_group_id is not null
81: AND trst.step_completion_ind = 'N'
82: UNION
83: (SELECT distinct trst.step_group_id
84: FROM igs_tr_step trst
85: WHERE trst.tracking_id = cp_tracking_id
86: AND trst.tracking_step_number > cp_tracking_step_number
87: AND trst.step_group_id is not null
88: AND trst.step_completion_ind = 'Y'

Line 92: FROM igs_tr_step trst

88: AND trst.step_completion_ind = 'Y'
89: GROUP BY trst.step_group_id , trst.step_completion_ind
90: MINUS
91: SELECT distinct trst.step_group_id
92: FROM igs_tr_step trst
93: WHERE trst.tracking_id = cp_tracking_id
94: AND trst.tracking_step_number < cp_tracking_step_number
95: AND trst.step_group_id is not null
96: GROUP BY trst.step_group_id , trst.step_completion_ind

Line 235: p_message_name := 'IGS_TR_STEP_TYPE_INVALID';

231: OPEN tracking_type_cur;
232: FETCH tracking_type_cur INTO l_s_tracking_type;
233: IF tracking_type_cur%NOTFOUND THEN
234: CLOSE tracking_type_cur;
235: p_message_name := 'IGS_TR_STEP_TYPE_INVALID';
236: RETURN FALSE;
237: END IF;
238: CLOSE tracking_type_cur;
239:

Line 245: p_message_name := 'IGS_TR_STEP_TYPE_INVALID';

241: OPEN step_type_cur(l_s_tracking_type);
242: FETCH step_type_cur INTO l_dummy;
243: IF step_type_cur%NOTFOUND THEN
244: CLOSE step_type_cur;
245: p_message_name := 'IGS_TR_STEP_TYPE_INVALID';
246: RETURN FALSE;
247: END IF;
248: CLOSE step_type_cur;
249: