65: p_message_name OUT NOCOPY VARCHAR2 )
66: RETURN BOOLEAN;
67:
68: Procedure Admp_Ins_Aa_Hist(
69: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
70: p_admission_appl_number IN NUMBER ,
71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
67:
68: Procedure Admp_Ins_Aa_Hist(
69: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
70: p_admission_appl_number IN NUMBER ,
71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
68: Procedure Admp_Ins_Aa_Hist(
69: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
70: p_admission_appl_number IN NUMBER ,
71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
76: p_old_acad_ci_sequence_number IN NUMBER ,
69: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,
70: p_admission_appl_number IN NUMBER ,
71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
76: p_old_acad_ci_sequence_number IN NUMBER ,
77: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
70: p_admission_appl_number IN NUMBER ,
71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
76: p_old_acad_ci_sequence_number IN NUMBER ,
77: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
76: p_old_acad_ci_sequence_number IN NUMBER ,
77: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
79: p_new_adm_ci_sequence_number IN NUMBER ,
80: p_old_adm_ci_sequence_number IN NUMBER ,
81: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,
75: p_new_acad_ci_sequence_number IN NUMBER ,
76: p_old_acad_ci_sequence_number IN NUMBER ,
77: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
79: p_new_adm_ci_sequence_number IN NUMBER ,
80: p_old_adm_ci_sequence_number IN NUMBER ,
81: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
77: p_new_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
79: p_new_adm_ci_sequence_number IN NUMBER ,
80: p_old_adm_ci_sequence_number IN NUMBER ,
81: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
83: p_new_s_admission_process_type IN VARCHAR2 ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_cal_type%TYPE ,
79: p_new_adm_ci_sequence_number IN NUMBER ,
80: p_old_adm_ci_sequence_number IN NUMBER ,
81: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
83: p_new_s_admission_process_type IN VARCHAR2 ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
81: p_new_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
83: p_new_s_admission_process_type IN VARCHAR2 ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,
83: p_new_s_admission_process_type IN VARCHAR2 ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
83: p_new_s_admission_process_type IN VARCHAR2 ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
84: p_old_s_admission_process_type IN VARCHAR2 ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
85: p_new_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%TYPE ,
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
95:
88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%TYPE ,
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
95:
96: Procedure Admp_Ins_Acaiu_Hist(
89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
95:
96: Procedure Admp_Ins_Acaiu_Hist(
97: p_person_id IN NUMBER ,
90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%TYPE ,
91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%TYPE ,
93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE ,
94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%TYPE );
95:
96: Procedure Admp_Ins_Acaiu_Hist(
97: p_person_id IN NUMBER ,
98: p_admission_appl_number IN NUMBER ,