eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_AS_RATE

Line 15: -- datatype residency_status_cd in igs_fi_fee_as_rate table.

11: -- Added 4 new params for unit_set_cd and us_version_number in procedure finp_ins_far_hist()
12: --shtatiko 30-MAY-2003 Enh# 2831582, Added new column designated_payment_flag. As an impact modified finp_ins_ft_hist.
13: -- npalanis 23-OCT-2002 Bug : 2608360
14: -- p_new and p_old residency_status_id column is changed to p_residency_status_cd of
15: -- datatype residency_status_cd in igs_fi_fee_as_rate table.
16: --vvutukur 13-Sep-2002 Enh#2564643.Modifications done in procedure finp_ins_ft_hist.
17: --smvk 28-Aug-2002 Procedure finp_ins_fdf_hist is obsolete as part of Build SFCR005_Cleanup_Build (Enhancement Bug # 2531390)
18: --vvutukur 28-Aug-2002 Bug#2531390.Removed the procedure finp_ins_fps_hist.
19: --jbegum 26-Aug-2002 As part of Enh Bug#2531390 the procedure finp_ins_pps_hist was removed.

Line 327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,

323: APP_EXCEPTION.RAISE_EXCEPTION;
324: END finp_ins_er_hist;
325: --
326: PROCEDURE finp_ins_far_hist(
327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,

Line 328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,

324: END finp_ins_er_hist;
325: --
326: PROCEDURE finp_ins_far_hist(
327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

Line 329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,

325: --
326: PROCEDURE finp_ins_far_hist(
327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

Line 330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,

326: PROCEDURE finp_ins_far_hist(
327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

Line 331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,

327: p_fee_type IN IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE ,
328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

Line 332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

328: p_fee_cal_type IN IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE ,
329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

Line 333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,

329: p_fee_ci_sequence_number IN IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE ,
330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

Line 334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

330: p_s_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

Line 335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,

331: p_rate_number IN IGS_FI_FEE_AS_RATE.rate_number%TYPE ,
332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

Line 336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

332: p_new_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

Line 337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,

333: p_old_fee_cat IN IGS_FI_FEE_AS_RATE.FEE_CAT%TYPE ,
334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

Line 338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

334: p_new_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

Line 339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,

335: p_old_location_cd IN IGS_FI_FEE_AS_RATE.location_cd%TYPE ,
336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

Line 340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

336: p_new_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

Line 341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,

337: p_old_attendance_type IN IGS_FI_FEE_AS_RATE.ATTENDANCE_TYPE%TYPE ,
338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

Line 342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

338: p_new_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

Line 343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,

339: p_old_attendance_mode IN IGS_FI_FEE_AS_RATE.ATTENDANCE_MODE%TYPE ,
340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

Line 344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

340: p_new_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

Line 345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,

341: p_old_order_of_precedence IN IGS_FI_FEE_AS_RATE.order_of_precedence%TYPE ,
342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

Line 346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

342: p_new_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,

Line 347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,

343: p_old_govt_hecs_payment_option IN IGS_FI_FEE_AS_RATE.GOVT_HECS_PAYMENT_OPTION%TYPE ,
344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,

Line 348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

344: p_new_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,

Line 349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,

345: p_old_govt_hecs_cntrbtn_band IN IGS_FI_FEE_AS_RATE.govt_hecs_cntrbtn_band%TYPE ,
346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,

Line 350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,

346: p_new_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,

Line 351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,

347: p_old_chg_rate IN IGS_FI_FEE_AS_RATE.chg_rate%TYPE ,
348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,

Line 352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,

348: p_new_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,

Line 353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,

349: p_old_unit_class IN IGS_FI_FEE_AS_RATE.unit_class%TYPE ,
350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,

Line 354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,

350: p_new_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,

Line 355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,

351: p_old_residency_status_cd IN IGS_FI_FEE_AS_RATE.residency_status_cd%TYPE,
352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,

Line 356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,

352: p_new_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,

Line 357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,

353: p_old_course_cd IN IGS_FI_FEE_AS_RATE.course_cd%TYPE,
354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,

Line 358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,

354: p_new_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,

Line 359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,

355: p_old_version_number IN IGS_FI_FEE_AS_RATE.version_number%TYPE,
356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,

Line 360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,

356: p_new_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,

Line 361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,

357: p_old_org_party_id IN IGS_FI_FEE_AS_RATE.org_party_id%TYPE,
358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,

Line 362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,

358: p_new_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,

Line 363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,

359: p_old_class_standing IN IGS_FI_FEE_AS_RATE.class_standing%TYPE,
360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,

Line 364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,

360: p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

Line 365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,

361: p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,

Line 366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,

362: p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

Line 367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,

363: p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,

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

364: p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

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

365: p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,

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

366: p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

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

367: p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,

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

368: p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,

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

369: p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
377: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL

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

370: p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
377: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
378: ) AS

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

371: p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
377: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
378: ) AS
379: /*******************************************************************************************/

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

372: p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
377: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
378: ) AS
379: /*******************************************************************************************/
380: -- HISTORY

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

373: p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
374: p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
375: p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
376: p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
377: p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
378: ) AS
379: /*******************************************************************************************/
380: -- HISTORY
381: --Who When What

Line 395: -- Create a history for a IGS_FI_FEE_AS_RATE record.

391: r_farh IGS_FI_FEE_AS_RT_H_ALL%ROWTYPE;
392: v_create_history BOOLEAN := FALSE;
393: l_n_org_id IGS_FI_FEE_AS_RT_H_ALL.org_id%TYPE := igs_ge_gen_003.get_org_id;
394: BEGIN
395: -- Create a history for a IGS_FI_FEE_AS_RATE record.
396: -- Check if any of the non-primary key fields have been changed
397: -- and set the flag v_create_history to indicate so.
398: IF NVL(p_new_fee_cat, 'NULL') <> NVL(p_old_fee_cat, 'NULL') THEN
399: r_farh.FEE_CAT := p_old_fee_cat;

Line 435: -- Code added for New Field Unit Class added to the IGS_FI_FEE_AS_RATE table

431: r_farh.chg_rate := p_old_chg_rate;
432: v_create_history := TRUE;
433: END IF;
434:
435: -- Code added for New Field Unit Class added to the IGS_FI_FEE_AS_RATE table
436: IF ((p_new_unit_class <> p_old_unit_class) OR
437: ((p_new_unit_class IS NOT NULL AND p_old_unit_class IS NULL) OR
438: (p_new_unit_class IS NULL AND p_old_unit_class IS NOT NULL))) THEN
439: r_farh.unit_class := p_old_unit_class;

Line 442: -- Code added for five New Fields added to the IGS_FI_FEE_AS_RATE table

438: (p_new_unit_class IS NULL AND p_old_unit_class IS NOT NULL))) THEN
439: r_farh.unit_class := p_old_unit_class;
440: v_create_history := TRUE;
441: END IF;
442: -- Code added for five New Fields added to the IGS_FI_FEE_AS_RATE table
443: IF NVL(p_new_residency_status_cd,0) <> NVL(p_old_residency_status_cd,0) THEN
444: r_farh.residency_status_cd := p_old_residency_status_cd;
445: v_create_history := TRUE;
446: END IF;