DBA Data[Home] [Help]

APPS.IGS_AD_GEN_010 dependencies on IGS_AD_APPL_ALL

Line 69: p_person_id IN IGS_AD_APPL_ALL.person_id%TYPE ,

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 ,

Line 71: p_new_appl_dt IN IGS_AD_APPL_ALL.appl_dt%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 ,

Line 72: p_old_appl_dt IN IGS_AD_APPL_ALL.appl_dt%TYPE ,

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 ,

Line 73: p_new_acad_cal_type IN IGS_AD_APPL_ALL.acad_cal_type%TYPE ,

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 ,

Line 74: p_old_acad_cal_type IN IGS_AD_APPL_ALL.acad_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 ,

Line 77: p_new_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 ,

Line 78: p_old_adm_cal_type IN IGS_AD_APPL_ALL.adm_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 ,
82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%TYPE ,

Line 81: p_new_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 ,

Line 82: p_old_admission_cat IN IGS_AD_APPL_ALL.admission_cat%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 ,

Line 85: p_new_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 ,

Line 86: p_old_adm_appl_status IN IGS_AD_APPL_ALL.adm_appl_status%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 ,

Line 87: p_new_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%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 ,

Line 88: p_old_adm_fee_status IN IGS_AD_APPL_ALL.adm_fee_status%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 ,

Line 89: p_new_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%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 ,

Line 90: p_old_tac_appl_ind IN IGS_AD_APPL_ALL.tac_appl_ind%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 );

Line 91: p_new_update_who IN IGS_AD_APPL_ALL.last_updated_by%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:

Line 92: p_old_update_who IN IGS_AD_APPL_ALL.last_updated_by%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:
96: Procedure Admp_Ins_Acaiu_Hist(

Line 93: p_new_update_on IN IGS_AD_APPL_ALL.last_update_date%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(
97: p_person_id IN NUMBER ,

Line 94: p_old_update_on IN IGS_AD_APPL_ALL.last_update_date%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 ,
98: p_admission_appl_number IN NUMBER ,