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_RATINGS_PUB dependencies on IGS_AD_APPL_ARP_V

Line 201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,

197: p_validation_level IN NUMBER default FND_API.G_VALID_LEVEL_FULL,
198:
199: --Standard parameter ends
200:
201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,

Line 202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,

198:
199: --Standard parameter ends
200:
201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,
206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,

Line 203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,

199: --Standard parameter ends
200:
201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,
206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,
207:

Line 204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,

200:
201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,
206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,
207:
208: x_return_status OUT NOCOPY VARCHAR2,

Line 205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,

201: p_person_id IN igs_ad_appl_arp_v.PERSON_ID%TYPE ,
202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,
206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,

Line 206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,

202: p_admission_appl_number IN igs_ad_appl_arp_v.ADMISSION_APPL_NUMBER%TYPE ,
203: p_nominated_program_cd IN igs_ad_appl_arp_v.NOMINATED_COURSE_CD%TYPE,
204: p_sequence_number IN igs_ad_appl_arp_v.SEQUENCE_NUMBER%TYPE,
205: p_appl_rev_profile_id IN igs_ad_appl_arp_v.APPL_REV_PROFILE_ID%TYPE,
206: p_appl_revprof_revgr_id IN igs_ad_appl_arp_v.APPL_REVPROF_REVGR_ID%TYPE,
207:
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2

Line 303: FROM igs_ad_appl_arp_v

299: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
300: l_seq_num igs_ad_appl_arp.sequence_number%TYPE
301: ) IS
302: SELECT *
303: FROM igs_ad_appl_arp_v
304: WHERE person_id = l_person_id
305: AND admission_appl_number = l_adm_apl_num
306: AND nominated_course_cd = l_nom_crs_cd
307: AND sequence_number = l_seq_num ;

Line 342: l_exist_arp igs_ad_appl_arp_v%ROWTYPE;

338: AND doc.adm_doc_status = apl.adm_doc_status;
339:
340: l_adm_doc igs_ad_ps_appl_inst.adm_doc_status%TYPE;
341: l_rating igs_ad_appl_eval_v.rating%TYPE;
342: l_exist_arp igs_ad_appl_arp_v%ROWTYPE;
343: l_modif_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
344: l_exist_eval_type igs_ad_apl_rev_prf_all.sequential_concurrent_ind%TYPE;
345: l_get_current_eval VARCHAR2(1);
346: l_c_aplinst_cur c_aplinst_cur%ROWTYPE;