DBA Data[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_AS_RATE

Line 106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,

102: p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
103: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE );
104: --
105: PROCEDURE finp_ins_far_hist(
106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,

Line 107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,

103: p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE );
104: --
105: PROCEDURE finp_ins_far_hist(
106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

Line 108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,

104: --
105: PROCEDURE finp_ins_far_hist(
106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

Line 109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,

105: PROCEDURE finp_ins_far_hist(
106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

Line 110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,

106: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

Line 111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

107: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

Line 112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

108: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

Line 113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

109: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

Line 114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

110: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

Line 115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

111: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

Line 116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

112: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

Line 117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

113: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

Line 118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

114: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

Line 119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

115: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

Line 120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

116: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

Line 121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

117: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

Line 122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

118: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

Line 123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

119: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

Line 124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

120: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

Line 125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

121: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586

Line 126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

122: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,

Line 127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

123: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,

Line 128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

124: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
125: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,

Line 130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,

126: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,

Line 131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,

127: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,

Line 132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,

128: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,

Line 133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,

129: -- Added by Nishikant , to include the following five new fields for enhancement bug#1851586
130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,

Line 134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,

130: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,

Line 135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,

131: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE DEFAULT NULL,
132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,

Line 136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,

132: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,

Line 137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,

133: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE DEFAULT NULL,
134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,

Line 138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,

134: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,

Line 139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,

135: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE DEFAULT NULL,
136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,

Line 140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,

136: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,

Line 141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,

137: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE DEFAULT NULL,
138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,

Line 142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,

138: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,

Line 143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,

139: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE DEFAULT NULL,
140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,

Line 144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,

140: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

Line 145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,

141: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE DEFAULT NULL,
142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

Line 146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,

142: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

Line 147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,

143: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE DEFAULT NULL,
144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

Line 148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

144: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

Line 149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

145: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE DEFAULT NULL,
146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

Line 150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

146: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

Line 151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

147: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE DEFAULT NULL,
148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

Line 152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

148: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,

Line 153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

149: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL

Line 154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

150: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
158:

Line 155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

151: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
158:
159: );

Line 156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,

152: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
158:
159: );
160: --

Line 157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL

153: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
154: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
155: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
156: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
157: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
158:
159: );
160: --
161: PROCEDURE finp_ins_fcci_hist(