DBA Data[Home] [Help]

APPS.IGS_FI_VAL_FAS dependencies on IGS_FI_FEE_AS_ALL

Line 35: -- Validate IGS_FI_FEE_AS_ALL.SI_FI_S_TRN_TYPE for a manual assessment.

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;

Line 102: p_new_person_id IGS_FI_FEE_AS_ALL.person_id%TYPE ,

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 ,

Line 103: p_old_person_id IGS_FI_FEE_AS_ALL.person_id%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 ,

Line 104: p_new_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%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 ,

Line 105: p_old_transaction_id IGS_FI_FEE_AS_ALL.transaction_id%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 ,

Line 106: p_new_fee_type IGS_FI_FEE_AS_ALL.fee_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 ,

Line 107: p_old_fee_type IGS_FI_FEE_AS_ALL.fee_type%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 ,

Line 108: p_new_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%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 ,

Line 109: p_old_fee_cal_type IGS_FI_FEE_AS_ALL.fee_cal_type%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 ,

Line 110: p_new_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%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,

Line 111: p_old_fee_ci_seq_num IGS_FI_FEE_AS_ALL.fee_ci_sequence_number%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 ,

Line 112: p_new_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%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 ,

Line 113: p_old_fee_cat IGS_FI_FEE_AS_ALL.fee_cat%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 ,

Line 114: p_new_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_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 ,
118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%TYPE ,

Line 115: p_old_transaction_type IGS_FI_FEE_AS_ALL.s_transaction_type%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 ,

Line 116: p_new_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%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 ,

Line 117: p_old_transaction_dt IGS_FI_FEE_AS_ALL.transaction_dt%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 ,

Line 118: p_new_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%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 ,

Line 119: p_old_transaction_amount IGS_FI_FEE_AS_ALL.transaction_amount%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 ,

Line 120: p_new_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%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 ,

Line 121: p_old_currency_cd IGS_FI_FEE_AS_ALL.currency_cd%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 ,

Line 122: p_new_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%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 ,

Line 123: p_old_exchange_rate IGS_FI_FEE_AS_ALL.exchange_rate%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 ,

Line 124: p_new_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%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 ,

Line 125: p_old_chg_elements IGS_FI_FEE_AS_ALL.chg_elements%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 ,

Line 126: p_new_effective_dt IGS_FI_FEE_AS_ALL.effective_dt%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 ,

Line 127: p_old_effective_dt IGS_FI_FEE_AS_ALL.effective_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 ,

Line 128: p_new_course_cd IGS_FI_FEE_AS_ALL.course_cd%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 ,

Line 129: p_old_course_cd IGS_FI_FEE_AS_ALL.course_cd%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 ,

Line 130: p_new_notification_dt IGS_FI_FEE_AS_ALL.notification_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 )

Line 131: p_old_notification_dt IGS_FI_FEE_AS_ALL.notification_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 )
135: RETURN BOOLEAN;

Line 132: p_new_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_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;
136: PRAGMA RESTRICT_REFERENCES(finp_val_fas_upd,WNDS);

Line 133: p_old_logical_delete_dt IGS_FI_FEE_AS_ALL.logical_delete_dt%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);
137: END IGS_FI_VAL_FAS;