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_UNIT_FEE_TRG

Line 1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,

1160: -- As part of Enh Bug#2531390 the procedure finp_ins_pps_hist was removed
1161: --
1162:
1163: PROCEDURE finp_ins_uft_hist(
1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

Line 1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,

1161: --
1162:
1163: PROCEDURE finp_ins_uft_hist(
1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,

Line 1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,

1162:
1163: PROCEDURE finp_ins_uft_hist(
1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

Line 1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,

1163: PROCEDURE finp_ins_uft_hist(
1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

Line 1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,

1164: p_fee_cat IN IGS_FI_UNIT_FEE_TRG.FEE_CAT%TYPE ,
1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

Line 1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,

1165: p_fee_cal_type IN IGS_FI_UNIT_FEE_TRG.fee_cal_type%TYPE ,
1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

Line 1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

1166: p_fee_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.fee_ci_sequence_number%TYPE ,
1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,

Line 1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,

1167: p_fee_type IN IGS_FI_UNIT_FEE_TRG.FEE_TYPE%TYPE ,
1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,

Line 1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

1168: p_unit_cd IN IGS_FI_UNIT_FEE_TRG.unit_cd%TYPE ,
1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

Line 1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,

1169: p_sequence_number IN IGS_FI_UNIT_FEE_TRG.sequence_number%TYPE ,
1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

Line 1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,

1170: p_new_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,

Line 1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,

1171: p_old_version_number IN IGS_FI_UNIT_FEE_TRG.version_number%TYPE ,
1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,

Line 1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

1172: p_new_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

Line 1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,

1173: p_old_cal_type IN IGS_FI_UNIT_FEE_TRG.CAL_TYPE%TYPE ,
1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

Line 1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,

1174: p_new_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,

Line 1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,

1175: p_old_ci_sequence_number IN IGS_FI_UNIT_FEE_TRG.ci_sequence_number%TYPE ,
1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,

Line 1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

1176: p_new_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,

Line 1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,

1177: p_old_location_cd IN IGS_FI_UNIT_FEE_TRG.location_cd%TYPE ,
1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,

Line 1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,

1178: p_new_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,

Line 1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,

1179: p_old_unit_class IN IGS_FI_UNIT_FEE_TRG.UNIT_CLASS%TYPE ,
1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )

Line 1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,

1180: p_new_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )
1188: AS

Line 1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,

1181: p_old_create_dt IN IGS_FI_UNIT_FEE_TRG.create_dt%TYPE ,
1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )
1188: AS
1189: gv_other_detail VARCHAR2(255);

Line 1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,

1182: p_new_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )
1188: AS
1189: gv_other_detail VARCHAR2(255);
1190: BEGIN

Line 1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )

1183: p_old_fee_trigger_group_number IN IGS_FI_UNIT_FEE_TRG.fee_trigger_group_number%TYPE ,
1184: p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1185: p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
1186: p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
1187: p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )
1188: AS
1189: gv_other_detail VARCHAR2(255);
1190: BEGIN
1191: DECLARE

Line 1197: -- Create a history for a IGS_FI_UNIT_FEE_TRG record.

1193: r_ufth IGS_FI_UNIT_FEE_TR_H%ROWTYPE;
1194: v_create_history BOOLEAN := FALSE;
1195: l_n_org_id IGS_FI_UNIT_FEE_TR_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
1196: BEGIN
1197: -- Create a history for a IGS_FI_UNIT_FEE_TRG record.
1198: -- Check if any of the non-primary key fields have been changed
1199: -- and set the flag v_create_history to indicate so.
1200: IF NVL(p_new_version_number, 0) <> NVL(p_old_version_number, 0) THEN
1201: r_ufth.version_number := p_old_version_number;