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_EN_GEN_LEGACY dependencies on IGS_EN_STDNT_PS_ATT

Line 88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

84: p_class_standing IN igs_pr_class_std.class_standing%TYPE)
85: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE;
86:
87: FUNCTION get_course_att_status(
88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,

Line 89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

85: RETURN igs_pr_class_std.igs_pr_class_std_id%TYPE;
86:
87: FUNCTION get_course_att_status(
88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

Line 90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,

86:
87: FUNCTION get_course_att_status(
88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

Line 91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,

87: FUNCTION get_course_att_status(
88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,

Line 92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,

88: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96: p_course_type IN igs_ps_type.course_type%TYPE,

Line 93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

89: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96: p_course_type IN igs_ps_type.course_type%TYPE,
97: p_career_flag IN VARCHAR2)

Line 94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

90: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96: p_course_type IN igs_ps_type.course_type%TYPE,
97: p_career_flag IN VARCHAR2)
98: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;

Line 95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,

91: p_discontinued_dt IN igs_en_stdnt_ps_att.discontinued_dt%TYPE,
92: p_lapsed_dt IN igs_en_stdnt_ps_att.lapsed_dt%TYPE,
93: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96: p_course_type IN igs_ps_type.course_type%TYPE,
97: p_career_flag IN VARCHAR2)
98: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;
99:

Line 98: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;

94: p_primary_pg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
95: p_primary_prog_type_source IN igs_en_stdnt_ps_att.primary_prog_type_source%TYPE,
96: p_course_type IN igs_ps_type.course_type%TYPE,
97: p_career_flag IN VARCHAR2)
98: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;
99:
100: FUNCTION get_sca_dropped_by
101: RETURN igs_en_stdnt_ps_att.dropped_by%TYPE;
102:

Line 101: RETURN igs_en_stdnt_ps_att.dropped_by%TYPE;

97: p_career_flag IN VARCHAR2)
98: RETURN igs_en_stdnt_ps_att.course_attempt_status%TYPE;
99:
100: FUNCTION get_sca_dropped_by
101: RETURN igs_en_stdnt_ps_att.dropped_by%TYPE;
102:
103: FUNCTION get_sca_prog_type(
104: p_course_cd IN igs_ps_ver.course_cd%TYPE,
105: p_version_number IN igs_ps_ver.version_number%TYPE)

Line 109: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,

105: p_version_number IN igs_ps_ver.version_number%TYPE)
106: RETURN igs_ps_ver.course_type%TYPE;
107:
108: FUNCTION val_sca_start_dt (
109: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
110: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
111: RETURN BOOLEAN;
112:
113: FUNCTION val_sca_disc_date(

Line 110: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)

106: RETURN igs_ps_ver.course_type%TYPE;
107:
108: FUNCTION val_sca_start_dt (
109: p_student_confirmed_ind IN igs_en_stdnt_ps_att.student_confirmed_ind%TYPE,
110: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
111: RETURN BOOLEAN;
112:
113: FUNCTION val_sca_disc_date(
114: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)

Line 114: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)

110: p_commencement_dt IN igs_en_stdnt_ps_att.commencement_dt%TYPE)
111: RETURN BOOLEAN;
112:
113: FUNCTION val_sca_disc_date(
114: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)
115: RETURN BOOLEAN;
116:
117: FUNCTION val_sca_reqcmpl_dt(
118: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

Line 118: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,

114: p_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE)
115: RETURN BOOLEAN;
116:
117: FUNCTION val_sca_reqcmpl_dt(
118: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
119: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
120: p_message_name OUT NOCOPY VARCHAR2)
121: RETURN BOOLEAN;
122:

Line 119: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,

115: RETURN BOOLEAN;
116:
117: FUNCTION val_sca_reqcmpl_dt(
118: p_course_rqrmnt_comp_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE,
119: p_course_rqrmnts_comp_dt IN igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE,
120: p_message_name OUT NOCOPY VARCHAR2)
121: RETURN BOOLEAN;
122:
123: FUNCTION val_sca_key_prg(

Line 124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

120: p_message_name OUT NOCOPY VARCHAR2)
121: RETURN BOOLEAN;
122:
123: FUNCTION val_sca_key_prg(
124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

Line 125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,

121: RETURN BOOLEAN;
122:
123: FUNCTION val_sca_key_prg(
124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
129: p_career_flag VARCHAR2)

Line 126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,

122:
123: FUNCTION val_sca_key_prg(
124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
129: p_career_flag VARCHAR2)
130: RETURN BOOLEAN;

Line 127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

123: FUNCTION val_sca_key_prg(
124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
129: p_career_flag VARCHAR2)
130: RETURN BOOLEAN;
131:

Line 128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

124: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
125: p_course_cd IN igs_en_stdnt_ps_att.course_cd%TYPE,
126: p_key_program IN igs_en_stdnt_ps_att.key_program%TYPE,
127: p_primary_prg_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
128: p_course_attempt_st IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
129: p_career_flag VARCHAR2)
130: RETURN BOOLEAN;
131:
132: FUNCTION val_sca_primary_pg(

Line 133: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,

129: p_career_flag VARCHAR2)
130: RETURN BOOLEAN;
131:
132: FUNCTION val_sca_primary_pg(
133: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
134: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
135: p_course_type IN igs_ps_type.course_type%TYPE)
136: RETURN BOOLEAN;
137:

Line 134: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,

130: RETURN BOOLEAN;
131:
132: FUNCTION val_sca_primary_pg(
133: p_person_id IN igs_en_stdnt_ps_att.person_id%TYPE,
134: p_primary_prog_type IN igs_en_stdnt_ps_att.primary_program_type%TYPE,
135: p_course_type IN igs_ps_type.course_type%TYPE)
136: RETURN BOOLEAN;
137:
138: FUNCTION val_sca_comp_flag (

Line 139: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,

135: p_course_type IN igs_ps_type.course_type%TYPE)
136: RETURN BOOLEAN;
137:
138: FUNCTION val_sca_comp_flag (
139: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
140: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
141: RETURN BOOLEAN;
142:
143: FUNCTION val_sca_per_type(

Line 140: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)

136: RETURN BOOLEAN;
137:
138: FUNCTION val_sca_comp_flag (
139: p_course_attempt_status IN igs_en_stdnt_ps_att.course_attempt_status%TYPE,
140: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
141: RETURN BOOLEAN;
142:
143: FUNCTION val_sca_per_type(
144: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,

Line 144: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,

140: p_course_rqrmnt_complete_ind IN igs_en_stdnt_ps_att.course_rqrmnt_complete_ind%TYPE)
141: RETURN BOOLEAN;
142:
143: FUNCTION val_sca_per_type(
144: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
145: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
146: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
147: RETURN BOOLEAN;
148:

Line 145: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

141: RETURN BOOLEAN;
142:
143: FUNCTION val_sca_per_type(
144: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
145: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
146: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
147: RETURN BOOLEAN;
148:
149:

Line 146: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)

142:
143: FUNCTION val_sca_per_type(
144: p_person_id igs_en_stdnt_ps_att.person_id%TYPE,
145: p_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
146: p_course_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE)
147: RETURN BOOLEAN;
148:
149:
150:

Line 206: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE

202: FUNCTION check_sca_status_upd (
203: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
204: p_program_cd IN igs_en_stdnt_ps_intm.course_cd%TYPE,
205: p_called_from IN VARCHAR2,
206: p_course_attempt_status OUT NOCOPY igs_en_stdnt_ps_att.course_attempt_status%TYPE
207: ) RETURN BOOLEAN;
208:
209: FUNCTION validate_awd_offer_pgm(
210: p_person_id IN NUMBER,