31: p_message_name OUT NOCOPY VARCHAR2 )
32: RETURN BOOLEAN;
33: PRAGMA RESTRICT_REFERENCES(finp_val_fas_retro,WNDS);
34: --
35: -- Validate IGS_FI_FEE_AS_ALL.SI_FI_S_TRN_TYPE for a manual assessment.
36: FUNCTION finp_val_fas_cat(
37: p_transaction_type IN VARCHAR2 ,
38: p_message_name OUT NOCOPY VARCHAR2 )
39: RETURN BOOLEAN;
98: -- masehgal 17-Jan-2002 ENH # 2170429
99: -- Obsoletion of SPONSOR_CD related parameters
100:
101: FUNCTION finp_val_fas_upd(
102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
99: -- Obsoletion of SPONSOR_CD related parameters
100:
101: FUNCTION finp_val_fas_upd(
102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
100:
101: FUNCTION finp_val_fas_upd(
102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
101: FUNCTION finp_val_fas_upd(
102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
134: p_message_name OUT NOCOPY VARCHAR2 )
127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%TYPE ,
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
134: p_message_name OUT NOCOPY VARCHAR2 )
135: RETURN BOOLEAN;
128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
134: p_message_name OUT NOCOPY VARCHAR2 )
135: RETURN BOOLEAN;
136: PRAGMA RESTRICT_REFERENCES(finp_val_fas_upd,WNDS);
129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%TYPE ,
130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_dt%TYPE ,
132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%TYPE ,
134: p_message_name OUT NOCOPY VARCHAR2 )
135: RETURN BOOLEAN;
136: PRAGMA RESTRICT_REFERENCES(finp_val_fas_upd,WNDS);
137: END IGS_FI_VAL_FAS;