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

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 297: l_person_id igs_ad_appl_arp.person_id%TYPE,

293: FROM igs_ad_apl_rev_prf_all
294: WHERE appl_rev_profile_id = l_appl_rev_profile_id;
295:
296: CURSOR c_get_appl_rev_profile_id (
297: l_person_id igs_ad_appl_arp.person_id%TYPE,
298: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
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

Line 298: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,

294: WHERE appl_rev_profile_id = l_appl_rev_profile_id;
295:
296: CURSOR c_get_appl_rev_profile_id (
297: l_person_id igs_ad_appl_arp.person_id%TYPE,
298: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
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 *

Line 299: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,

295:
296: CURSOR c_get_appl_rev_profile_id (
297: l_person_id igs_ad_appl_arp.person_id%TYPE,
298: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
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

Line 300: l_seq_num igs_ad_appl_arp.sequence_number%TYPE

296: CURSOR c_get_appl_rev_profile_id (
297: l_person_id igs_ad_appl_arp.person_id%TYPE,
298: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
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

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 324: l_person_id igs_ad_appl_arp.person_id%TYPE,

320: AND sequence_number = l_seq_num
321: AND rating IS NOT NULL;
322:
323: CURSOR doc_cur(
324: l_person_id igs_ad_appl_arp.person_id%TYPE,
325: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
326: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
327: l_seq_number igs_ad_appl_arp.sequence_number%TYPE)
328: IS

Line 325: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,

321: AND rating IS NOT NULL;
322:
323: CURSOR doc_cur(
324: l_person_id igs_ad_appl_arp.person_id%TYPE,
325: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
326: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
327: l_seq_number igs_ad_appl_arp.sequence_number%TYPE)
328: IS
329: SELECT

Line 326: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,

322:
323: CURSOR doc_cur(
324: l_person_id igs_ad_appl_arp.person_id%TYPE,
325: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
326: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
327: l_seq_number igs_ad_appl_arp.sequence_number%TYPE)
328: IS
329: SELECT
330: doc.s_adm_doc_status

Line 327: l_seq_number igs_ad_appl_arp.sequence_number%TYPE)

323: CURSOR doc_cur(
324: l_person_id igs_ad_appl_arp.person_id%TYPE,
325: l_adm_apl_num igs_ad_appl_arp.admission_appl_number%TYPE,
326: l_nom_crs_cd igs_ad_appl_arp.nominated_course_cd%TYPE,
327: l_seq_number igs_ad_appl_arp.sequence_number%TYPE)
328: IS
329: SELECT
330: doc.s_adm_doc_status
331: FROM

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;

Line 353: l_appl_arp_id igs_ad_appl_arp.appl_arp_id%TYPE ;

349: l_msg_index NUMBER := 0;
350: l_return_status VARCHAR2(1);
351: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
352:
353: l_appl_arp_id igs_ad_appl_arp.appl_arp_id%TYPE ;
354: lv_rowid VARCHAR2(25) ;
355: l_errbuf VARCHAR2(100);
356: l_retcode NUMBER;
357: BEGIN

Line 371: check_length('PERSON_ID', 'IGS_AD_APPL_ARP', length(p_person_id));

367: FND_MSG_PUB.initialize;
368: END IF;
369:
370: -- P_PERSON_ID
371: check_length('PERSON_ID', 'IGS_AD_APPL_ARP', length(p_person_id));
372: -- P_ADMISSION_APPL_NUMBER
373: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_ARP', length(p_admission_appl_number));
374: -- p_nominated_program_cd
375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));

Line 373: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_ARP', length(p_admission_appl_number));

369:
370: -- P_PERSON_ID
371: check_length('PERSON_ID', 'IGS_AD_APPL_ARP', length(p_person_id));
372: -- P_ADMISSION_APPL_NUMBER
373: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_ARP', length(p_admission_appl_number));
374: -- p_nominated_program_cd
375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));
376: -- P_SEQUENCE_NUMBER
377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));

Line 375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));

371: check_length('PERSON_ID', 'IGS_AD_APPL_ARP', length(p_person_id));
372: -- P_ADMISSION_APPL_NUMBER
373: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_ARP', length(p_admission_appl_number));
374: -- p_nominated_program_cd
375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));
376: -- P_SEQUENCE_NUMBER
377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));
378: -- P_APPL_REV_PROFILE_ID
379: check_length('APPL_REV_PROFILE_ID', 'IGS_AD_APPL_ARP', length(p_appl_rev_profile_id));

Line 377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));

373: check_length('ADMISSION_APPL_NUMBER', 'IGS_AD_APPL_ARP', length(p_admission_appl_number));
374: -- p_nominated_program_cd
375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));
376: -- P_SEQUENCE_NUMBER
377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));
378: -- P_APPL_REV_PROFILE_ID
379: check_length('APPL_REV_PROFILE_ID', 'IGS_AD_APPL_ARP', length(p_appl_rev_profile_id));
380: -- P_APPL_REVPROF_REVGR_ID
381: check_length('APPL_REVPROF_REVGR_ID', 'IGS_AD_APPL_ARP', length(p_appl_revprof_revgr_id));

Line 379: check_length('APPL_REV_PROFILE_ID', 'IGS_AD_APPL_ARP', length(p_appl_rev_profile_id));

375: check_length('NOMINATED_COURSE_CD', 'IGS_AD_APPL_ARP', length(p_nominated_program_cd));
376: -- P_SEQUENCE_NUMBER
377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));
378: -- P_APPL_REV_PROFILE_ID
379: check_length('APPL_REV_PROFILE_ID', 'IGS_AD_APPL_ARP', length(p_appl_rev_profile_id));
380: -- P_APPL_REVPROF_REVGR_ID
381: check_length('APPL_REVPROF_REVGR_ID', 'IGS_AD_APPL_ARP', length(p_appl_revprof_revgr_id));
382:
383: -- Initialize API return status to success

Line 381: check_length('APPL_REVPROF_REVGR_ID', 'IGS_AD_APPL_ARP', length(p_appl_revprof_revgr_id));

377: check_length('SEQUENCE_NUMBER', 'IGS_AD_APPL_ARP', length(p_sequence_number));
378: -- P_APPL_REV_PROFILE_ID
379: check_length('APPL_REV_PROFILE_ID', 'IGS_AD_APPL_ARP', length(p_appl_rev_profile_id));
380: -- P_APPL_REVPROF_REVGR_ID
381: check_length('APPL_REVPROF_REVGR_ID', 'IGS_AD_APPL_ARP', length(p_appl_revprof_revgr_id));
382:
383: -- Initialize API return status to success
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385: -- Check whether any application is available in OSS to update outcome status

Line 486: igs_ad_appl_arp_pkg.insert_row (

482:
483: BEGIN
484: IF l_exist_eval_type IS NULL THEN
485: -- insert row of Review Proifile
486: igs_ad_appl_arp_pkg.insert_row (
487: x_mode => 'I',
488: x_rowid => lv_rowid,
489: x_appl_arp_id => l_appl_arp_id,
490: x_person_id => p_PERSON_ID,

Line 499: igs_ad_appl_arp_pkg.update_Row (

495: x_appl_revprof_revgr_id => p_APPL_REVPROF_REVGR_ID
496: );
497: ELSE -- this case will never happen as we are not allowing the update of review profile
498: -- insert row of Review Proifile
499: igs_ad_appl_arp_pkg.update_Row (
500: x_mode => 'I',
501: x_rowid => l_exist_arp.row_id,
502: x_appl_arp_id => l_exist_arp.appl_arp_id,
503: x_person_id => p_PERSON_ID,