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_AV_VAL_ASU dependencies on IGS_AV_STND_UNIT_ALL

Line 147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,

143: RETURN BOOLEAN;
144:
145:
146: -- Record Type for the ref cursor that fetches the advance standing details.
147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,
148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,

Line 148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,

144:
145:
146: -- Record Type for the ref cursor that fetches the advance standing details.
147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,
148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,
152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);

Line 149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,

145:
146: -- Record Type for the ref cursor that fetches the advance standing details.
147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,
148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,
152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);
153:

Line 150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,

146: -- Record Type for the ref cursor that fetches the advance standing details.
147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,
148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,
152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);
153:
154: g_advcrrec adv_cr_rec;

Line 151: version_number igs_av_stnd_unit_all.version_number%TYPE,

147: TYPE adv_cr_rec IS RECORD (credit_percentage igs_av_stnd_unit_all.credit_percentage%TYPE,
148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,
152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);
153:
154: g_advcrrec adv_cr_rec;
155:

Line 152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);

148: exemption_institution_cd igs_av_stnd_unit_all.exemption_institution_cd%TYPE,
149: s_adv_stnd_granting_status igs_av_stnd_unit_all.s_adv_stnd_granting_status%TYPE,
150: unit_cd igs_av_stnd_unit_all.unit_cd%TYPE,
151: version_number igs_av_stnd_unit_all.version_number%TYPE,
152: achievable_credit_points igs_av_stnd_unit_all.achievable_credit_points%TYPE);
153:
154: g_advcrrec adv_cr_rec;
155:
156: -- Ref cursor that fetches the advance standing details dynamically depending on the values of previous_unit_cd,