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.IGF_AP_OSS_INTEGR dependencies on IGS_AD_PS_APPL_INST_ALL

Line 334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

330: p_awd_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
331: p_ad_appl_row_id OUT NOCOPY ROWID,
332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
335: p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,
336: p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
337: p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
338: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,

Line 335: p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,

331: p_ad_appl_row_id OUT NOCOPY ROWID,
332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
335: p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,
336: p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
337: p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
338: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,
339: p_multiple OUT NOCOPY VARCHAR2 )

Line 336: p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

332: p_ad_prog_appl_row_id OUT NOCOPY ROWID,
333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
335: p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,
336: p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
337: p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
338: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,
339: p_multiple OUT NOCOPY VARCHAR2 )
340: IS

Line 337: p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,

333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,
334: p_course_cd IN OUT NOCOPY igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
335: p_crv_version_number IN OUT NOCOPY igs_ad_ps_appl_inst_all.sequence_number%TYPE,
336: p_adm_offer_resp_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
337: p_adm_outcome_stat OUT NOCOPY igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE,
338: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%TYPE,
339: p_multiple OUT NOCOPY VARCHAR2 )
340: IS
341:

Line 383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

379: CURSOR c_get_adm_appl_details(p_person_id hz_parties.party_id%TYPE,
380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,
381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,
382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
384: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE) IS
385: SELECT aav.row_id appl_inst_row_id,
386: acai.row_id appl_prog_inst_row_id,
387: aav.person_id,

Line 384: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE) IS

380: c_cal_type igs_ca_inst_all.cal_type%TYPE ,
381: c_sequence_number igs_ca_inst_all.sequence_number%TYPE,
382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,
383: p_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
384: p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE) IS
385: SELECT aav.row_id appl_inst_row_id,
386: acai.row_id appl_prog_inst_row_id,
387: aav.person_id,
388: aav.admission_appl_number,

Line 506: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;

502: -- The OUT NOCOPY parameter variable to capture the values returned from the get_adm_appl_details procedure.
503: lv_ad_appl_row_id ROWID;
504: lv_ad_prog_appl_row_id ROWID;
505: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
506: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
507: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
508: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
509: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
510: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;

Line 507: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;

503: lv_ad_appl_row_id ROWID;
504: lv_ad_prog_appl_row_id ROWID;
505: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
506: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
507: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
508: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
509: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
510: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
511: lv_multiple VARCHAR2(10) ;

Line 555: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;

551: -- The OUT NOCOPY parameter variable to capture the values returned from the get_adm_appl_details procedure.
552: lv_ad_appl_row_id ROWID;
553: lv_ad_prog_appl_row_id ROWID;
554: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
555: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
556: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
557: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
558: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
559: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;

Line 556: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;

552: lv_ad_appl_row_id ROWID;
553: lv_ad_prog_appl_row_id ROWID;
554: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
555: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
556: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
557: lv_adm_offer_resp_stat igs_ad_ofr_resp_stat.adm_offer_resp_status%TYPE;
558: lv_adm_outcome_stat igs_ad_ou_stat.adm_outcome_status%TYPE;
559: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
560: lv_multiple VARCHAR2(10) ;