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_AD_SS_GEN_001 dependencies on IGS_AD_PS_APPL_INST

Line 159: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,

155: --Function to get the major first choice and second choice to be displayed in the printable page
156: -- Sent by Nagaraju from HQ to be added to the API
157: --------------------------------------------------------------------------------------------------
158: */
159: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
160: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
161: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
162: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
163: p_rank IN igs_ad_unit_sets.rank%TYPE)

Line 160: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,

156: -- Sent by Nagaraju from HQ to be added to the API
157: --------------------------------------------------------------------------------------------------
158: */
159: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
160: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
161: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
162: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
163: p_rank IN igs_ad_unit_sets.rank%TYPE)
164: RETURN VARCHAR2;

Line 161: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,

157: --------------------------------------------------------------------------------------------------
158: */
159: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
160: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
161: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
162: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
163: p_rank IN igs_ad_unit_sets.rank%TYPE)
164: RETURN VARCHAR2;
165:

Line 162: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,

158: */
159: FUNCTION get_major(p_person_id IN igs_ad_ps_appl_inst.person_id%TYPE,
160: p_admission_appl_number IN igs_ad_ps_appl_inst.admission_appl_number%TYPE,
161: p_nominated_course_cd IN igs_ad_ps_appl_inst.nominated_course_cd%TYPE,
162: p_sequence_number IN igs_ad_ps_appl_inst.sequence_number%TYPE,
163: p_rank IN igs_ad_unit_sets.rank%TYPE)
164: RETURN VARCHAR2;
165:
166: FUNCTION DATESTR(P_START_DATE DATE, P_END_DATE DATE, P_COMP_DATE DATE)