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_GEN_010 dependencies on IGS_AD_APPL

Line 293: FROM igs_ad_appl aa,

289: cp_attendance_mode IGS_PS_ENT_PT_REF_CD.attendance_mode%TYPE,
290: cp_attendance_type IGS_PS_ENT_PT_REF_CD.attendance_type%TYPE) IS
291: SELECT aors.s_adm_offer_resp_status,
292: aods.s_adm_offer_dfrmnt_status
293: FROM igs_ad_appl aa,
294: igs_ad_ps_appl_inst acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
295: igs_ad_ofr_resp_stat aors,
296: igs_ad_ofrdfrmt_stat aods
297: WHERE acaiv.person_id = cp_matched_id AND

Line 316: FROM igs_ad_appl aa,

312: SELECT aors.s_adm_offer_resp_status,
313: aods.s_adm_offer_dfrmnt_status,
314: acaiv.course_cd,
315: ceprc.reference_cd
316: FROM igs_ad_appl aa,
317: IGS_AD_PS_APPL_INST acaiv, /* Replaced IGS_AD_PS_APPL_INST_APLINST_V with IGS_AD_PS_APPL_INST. Bug 3150054 */
318: IGS_AD_OFR_RESP_STAT aors,
319: IGS_AD_OFRDFRMT_STAT aods,
320: IGS_PS_ENT_PT_REF_CD ceprc,

Line 565: v_acad_alternate_code IGS_AD_APPL_ADMAPPL_V.acad_alternate_code%TYPE;

561: -- for use on letters.
562: DECLARE
563: v_out_string VARCHAR2(200) DEFAULT NULL;
564: v_comm_period VARCHAR2(21) DEFAULT NULL;
565: v_acad_alternate_code IGS_AD_APPL_ADMAPPL_V.acad_alternate_code%TYPE;
566: CURSOR c_uv_acaiuv IS
567: SELECT acaiuv.unit_cd,
568: acaiuv.uv_version_number,
569: acaiuv.location_cd,

Line 591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */

587: acaiuv.location_cd,
588: acaiuv.unit_class,
589: acaiuv.unit_mode;
590: CURSOR c_aav IS
591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */
592: FROM igs_ad_appl aav,
593: igs_ca_inst ca
594: WHERE aav.person_id = p_person_id AND
595: aav.admission_appl_number = p_admission_appl_number AND

Line 592: FROM igs_ad_appl aav,

588: acaiuv.unit_class,
589: acaiuv.unit_mode;
590: CURSOR c_aav IS
591: SELECT ca.alternate_code acad_alternate_code /* Replace IGS_AD_APPL_ADMAPPL_V with IGS_AD_APPL and IGS_CA_INST tables Bug: 3150054 */
592: FROM igs_ad_appl aav,
593: igs_ca_inst ca
594: WHERE aav.person_id = p_person_id AND
595: aav.admission_appl_number = p_admission_appl_number AND
596: aav.acad_cal_type = ca.cal_type AND

Line 649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR

645: p_message_name OUT NOCOPY VARCHAR2 )
646: RETURN BOOLEAN IS
647: gv_other_detail VARCHAR2(255);
648: BEGIN -- admp_ins_aal
649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR
650: -- table
651: DECLARE
652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;
653: v_message_name varchar2(30);

Line 652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;

648: BEGIN -- admp_ins_aal
649: -- This module validates and inserts a record into the IGS_AD_APPL_LTR
650: -- table
651: DECLARE
652: v_sequence_num IGS_AD_APPL_LTR.sequence_number%TYPE;
653: v_message_name varchar2(30);
654: lv_rowid VARCHAR2(25);
655:
656:

Line 661: FROM IGS_AD_APPL_LTR

657:
658: -- Derive the next sequence number
659: CURSOR c_aal IS
660: SELECT NVL(MAX(sequence_number),0) + 1
661: FROM IGS_AD_APPL_LTR
662: WHERE person_id = p_person_id AND
663: admission_appl_number = p_admission_appl_number AND
664: correspondence_type = p_correspondence_type;
665: BEGIN

Line 697: IGS_AD_APPL_Ltr_Pkg.Insert_Row (

693: OPEN c_aal;
694: FETCH c_aal INTO v_sequence_num;
695: CLOSE c_aal;
696: -- Insert new record
697: IGS_AD_APPL_Ltr_Pkg.Insert_Row (
698: X_Mode => 'R',
699: X_RowId => lv_rowid,
700: X_Person_Id => p_person_id,
701: X_Admission_Appl_Number => p_admission_appl_number,

Line 757: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,

753: App_Exception.Raise_Exception;
754: END admp_ins_aal_commit;
755:
756: PROCEDURE Admp_Ins_Aa_Hist(
757: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
758: p_admission_appl_number IN NUMBER ,
759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,

Line 759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,

755:
756: PROCEDURE Admp_Ins_Aa_Hist(
757: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
758: p_admission_appl_number IN NUMBER ,
759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,

Line 760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,

756: PROCEDURE Admp_Ins_Aa_Hist(
757: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
758: p_admission_appl_number IN NUMBER ,
759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,
764: p_old_acad_ci_sequence_number IN NUMBER ,

Line 761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,

757: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
758: p_admission_appl_number IN NUMBER ,
759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,
764: p_old_acad_ci_sequence_number IN NUMBER ,
765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,

Line 762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,

758: p_admission_appl_number IN NUMBER ,
759: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
760: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,
764: p_old_acad_ci_sequence_number IN NUMBER ,
765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,

Line 765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,

761: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,
764: p_old_acad_ci_sequence_number IN NUMBER ,
765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
767: p_new_adm_ci_sequence_number IN NUMBER ,
768: p_old_adm_ci_sequence_number IN NUMBER ,
769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,

Line 766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,

762: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
763: p_new_acad_ci_sequence_number IN NUMBER ,
764: p_old_acad_ci_sequence_number IN NUMBER ,
765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
767: p_new_adm_ci_sequence_number IN NUMBER ,
768: p_old_adm_ci_sequence_number IN NUMBER ,
769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,

Line 769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,

765: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
767: p_new_adm_ci_sequence_number IN NUMBER ,
768: p_old_adm_ci_sequence_number IN NUMBER ,
769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
771: p_new_s_admission_process_type IN VARCHAR2 ,
772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,

Line 770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,

766: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
767: p_new_adm_ci_sequence_number IN NUMBER ,
768: p_old_adm_ci_sequence_number IN NUMBER ,
769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
771: p_new_s_admission_process_type IN VARCHAR2 ,
772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,

Line 773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,

769: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
771: p_new_s_admission_process_type IN VARCHAR2 ,
772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,

Line 774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,

770: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
771: p_new_s_admission_process_type IN VARCHAR2 ,
772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,

Line 775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,

771: p_new_s_admission_process_type IN VARCHAR2 ,
772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,

Line 776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,

772: p_old_s_admission_process_type IN VARCHAR2 ,
773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,

Line 777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,

773: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,

Line 778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,

774: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )

Line 779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,

775: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )
783: IS

Line 780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,

776: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )
783: IS
784: gv_other_detail VARCHAR2(255);

Line 781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,

777: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )
783: IS
784: gv_other_detail VARCHAR2(255);
785: BEGIN -- admp_ins_aa_hist

Line 782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )

778: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
779: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
780: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
781: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )
783: IS
784: gv_other_detail VARCHAR2(255);
785: BEGIN -- admp_ins_aa_hist
786: -- Create a history for an IGS_AD_APPL record

Line 786: -- Create a history for an IGS_AD_APPL record

782: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE )
783: IS
784: gv_other_detail VARCHAR2(255);
785: BEGIN -- admp_ins_aa_hist
786: -- Create a history for an IGS_AD_APPL record
787: DECLARE
788: v_aah_rec IGS_AD_APPL_HIST%ROWTYPE;
789: v_create_history BOOLEAN := FALSE;
790: lv_rowid VARCHAR2(25);

Line 788: v_aah_rec IGS_AD_APPL_HIST%ROWTYPE;

784: gv_other_detail VARCHAR2(255);
785: BEGIN -- admp_ins_aa_hist
786: -- Create a history for an IGS_AD_APPL record
787: DECLARE
788: v_aah_rec IGS_AD_APPL_HIST%ROWTYPE;
789: v_create_history BOOLEAN := FALSE;
790: lv_rowid VARCHAR2(25);
791: l_org_id NUMBER(15);
792:

Line 845: IGS_AD_APPL_Hist_Pkg.Insert_Row (

841: v_aah_rec.hist_end_dt := p_new_update_on;
842: v_aah_rec.hist_who := p_old_update_who;
843: l_org_id := igs_ge_gen_003.get_org_id;
844:
845: IGS_AD_APPL_Hist_Pkg.Insert_Row (
846: X_Mode => 'R',
847: X_RowId => lv_rowid,
848: X_Person_Id => v_aah_rec.person_id,
849: X_Admission_Appl_Number => v_aah_rec.admission_appl_number,