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.

[Home] [Help]

APPS.IGF_AP_OSS_INTEGR dependencies on IGS_AD_APPL

Line 333: p_adm_appl_number IN OUT NOCOPY igs_ad_appl_all.admission_appl_number%TYPE,

329: p_awd_cal_type IN igs_ca_inst_all.cal_type%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,

Line 338: p_adm_appl_status OUT NOCOPY igs_ad_appl_all.adm_appl_status%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:
342: /*************************************************************

Line 382: p_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE,

378:
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,

Line 398: FROM IGS_AD_APPL aav,

394: DECODE(apstat.s_adm_appl_status,'COMPLETED',9,'RECEIVED',10,'WITHDRAWN',11,23))) appl_selection_order,
395: acai.adm_offer_resp_status,
396: acai.adm_outcome_status,
397: aav.adm_appl_status
398: FROM IGS_AD_APPL aav,
399: IGS_AD_PS_APPL_INST acai,
400: IGS_PS_VER crv,
401: IGS_AD_APPL_STAT apstat,
402: IGS_AD_OU_STAT oustat,

Line 401: IGS_AD_APPL_STAT apstat,

397: aav.adm_appl_status
398: FROM IGS_AD_APPL aav,
399: IGS_AD_PS_APPL_INST acai,
400: IGS_PS_VER crv,
401: IGS_AD_APPL_STAT apstat,
402: IGS_AD_OU_STAT oustat,
403: IGS_AD_OFR_RESP_STAT rpstat
404: WHERE aav.person_id = acai.person_id (+)
405: AND aav.admission_appl_number = acai.admission_appl_number(+)

Line 494: Purpose :This is provided to get the rowid for igs_ad_appl table in the Selected Applicaition Record

490:
491: /*************************************************************
492: Created By : adhawan
493: Date Created On : 2001/06/07
494: Purpose :This is provided to get the rowid for igs_ad_appl table in the Selected Applicaition Record
495: which inturn is based on the Academic calendar corresponding to the Award Calendar being passed(last two parameters)
496: Change History
497: Who When What
498:

Line 505: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;

501:
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;

Line 510: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%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) ;
512: BEGIN
513:
514: get_adm_appl_details(p_person_id ,

Line 554: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;

550:
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;

Line 559: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%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) ;
561: BEGIN
562:
563: get_adm_appl_details(p_person_id ,