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.IGS_AD_GEN_010 dependencies on IGS_AD_APPL_ALL

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