[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
)
AS
gv_other_detail VARCHAR2(255);
r_cfarh.hist_start_dt := p_old_last_update_date;
r_cfarh.hist_end_dt := p_new_last_update_date;
r_cfarh.hist_who := p_old_last_updated_by;
IGS_FI_FEE_AS_RT_HT_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_person_id => r_cfarh.person_id,
X_course_cd => r_cfarh.course_cd,
X_FEE_TYPE => r_cfarh.FEE_TYPE,
X_start_dt => r_cfarh.start_dt,
X_hist_start_dt => r_cfarh.hist_start_dt,
X_hist_end_dt => r_cfarh.hist_end_dt,
X_hist_who => r_cfarh.hist_who,
X_end_dt => r_cfarh.end_dt,
X_location_cd => r_cfarh.location_cd,
X_ATTENDANCE_TYPE => r_cfarh.ATTENDANCE_TYPE,
X_ATTENDANCE_MODE => r_cfarh.ATTENDANCE_MODE,
X_chg_rate => r_cfarh.chg_rate,
X_lower_nrml_rate_ovrd_ind => r_cfarh.lower_nrml_rate_ovrd_ind,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )
AS
gv_other_detail VARCHAR2(255);
r_cfth.hist_start_dt := p_old_last_update_date;
r_cfth.hist_end_dt := p_new_last_update_date;
r_cfth.hist_who := p_old_last_updated_by;
IGS_PS_FEE_TRG_HIST_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_CAT => r_cfth.FEE_CAT,
X_fee_cal_type => r_cfth.fee_cal_type,
X_fee_ci_sequence_number => r_cfth.fee_ci_sequence_number,
X_FEE_TYPE => r_cfth.FEE_TYPE,
X_course_cd => r_cfth.course_cd,
X_sequence_number => r_cfth.sequence_number,
X_hist_start_dt => r_cfth.hist_start_dt,
X_hist_end_dt => r_cfth.hist_end_dt,
X_hist_who => r_cfth.hist_who,
X_version_number => r_cfth.version_number,
X_CAL_TYPE => r_cfth.CAL_TYPE,
X_location_cd => r_cfth.location_cd,
X_ATTENDANCE_MODE => r_cfth.ATTENDANCE_MODE,
X_ATTENDANCE_TYPE => r_cfth.ATTENDANCE_TYPE,
X_create_dt => r_cfth.create_dt,
X_fee_trigger_group_number => r_cfth.fee_trigger_group_number,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_ELM_RANGE.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_ELM_RANGE.last_update_date%TYPE )
AS
gv_other_detail VARCHAR2(255);
r_erh.hist_start_dt := p_old_last_update_date;
r_erh.hist_end_dt := p_new_last_update_date;
r_erh.hist_who := p_old_last_updated_by;
IGS_FI_ELM_RANGE_H_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_TYPE => r_erh.FEE_TYPE,
X_fee_cal_type => r_erh.fee_cal_type,
X_fee_ci_sequence_number => r_erh.fee_ci_sequence_number,
X_s_relation_type => r_erh.s_relation_type,
X_range_number => r_erh.range_number,
X_hist_start_dt => r_erh.hist_start_dt,
X_hist_end_dt => r_erh.hist_end_dt,
X_hist_who => r_erh.hist_who,
X_FEE_CAT => r_erh.FEE_CAT,
X_lower_range => r_erh.lower_range,
X_upper_range => r_erh.upper_range,
X_s_chg_method_type => r_erh.s_chg_method_type,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
p_old_last_updated_by IN IGS_FI_FEE_AS_RATE.last_updated_by%TYPE,
p_new_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
p_old_last_update_date IN IGS_FI_FEE_AS_RATE.last_update_date%TYPE,
p_new_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
p_old_unit_set_cd IN igs_fi_fee_as_rate.unit_set_cd%TYPE,
p_new_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
p_old_us_version_number IN igs_fi_fee_as_rate.us_version_number%TYPE,
p_new_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
p_old_unit_cd IN igs_fi_fee_as_rate.unit_cd%TYPE DEFAULT NULL,
p_new_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
p_old_unit_version_number IN igs_fi_fee_as_rate.unit_version_number%TYPE DEFAULT NULL,
p_new_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
p_old_unit_level IN igs_fi_fee_as_rate.unit_level%TYPE DEFAULT NULL,
p_new_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
p_old_unit_type_id IN igs_fi_fee_as_rate.unit_type_id%TYPE DEFAULT NULL,
p_new_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL,
p_old_unit_mode IN igs_fi_fee_as_rate.unit_mode%TYPE DEFAULT NULL
) AS
/*******************************************************************************************/
-- HISTORY
--Who When What
--svuppala 31-MAY-2005 Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
-- Unit Version and Unit Level
--pathipat 09-Sep-2003 Enh 3108052 - Add Unit Sets to Rate Table
-- Added 4 new params for unit_set_cd and us_version_number
/*******************************************************************************************/
gv_other_detail VARCHAR2(255);
r_farh.hist_start_dt := p_old_last_update_date;
r_farh.hist_end_dt := p_new_last_update_date;
r_farh.hist_who := p_old_last_updated_by;
igs_fi_fee_as_rt_h_pkg.insert_row(
x_rowid => x_rowid,
x_fee_type => r_farh.fee_type,
x_fee_cal_type => r_farh.fee_cal_type,
x_fee_ci_sequence_number => r_farh.fee_ci_sequence_number,
x_s_relation_type => r_farh.s_relation_type,
x_rate_number => r_farh.rate_number,
x_hist_start_dt => r_farh.hist_start_dt,
x_hist_end_dt => r_farh.hist_end_dt,
x_hist_who => r_farh.hist_who,
x_fee_cat => r_farh.fee_cat,
x_location_cd => r_farh.location_cd,
x_attendance_type => r_farh.attendance_type,
x_attendance_mode => r_farh.attendance_mode,
x_order_of_precedence => r_farh.order_of_precedence,
x_govt_hecs_payment_option => r_farh.govt_hecs_payment_option,
x_govt_hecs_cntrbtn_band => r_farh.govt_hecs_cntrbtn_band,
x_chg_rate => r_farh.chg_rate,
x_unit_class => r_farh.unit_class,
-- added by nishikant , to include the following five new fields for enhancement bug#1851586
x_residency_status_cd => r_farh.residency_status_cd,
x_course_cd => r_farh.course_cd,
x_version_number => r_farh.version_number,
x_org_party_id => r_farh.org_party_id,
x_class_standing => r_farh.class_standing,
x_org_id => l_n_org_id,
x_mode => 'R',
x_unit_set_cd => r_farh.unit_set_cd,
x_us_version_number => r_farh.us_version_number,
--svuppala Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code, Unit Version and Unit Level
x_unit_cd => r_farh.unit_cd,
x_unit_version_number => r_farh.unit_version_number,
x_unit_level => r_farh.unit_level ,
x_unit_type_id => r_farh.unit_type_id,
x_unit_mode => r_farh.unit_mode
);
p_new_last_updated_by IN IGS_FI_F_CAT_CA_INST.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_F_CAT_CA_INST.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_F_CAT_CA_INST.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_F_CAT_CA_INST.last_update_date%TYPE )
AS
gv_other_detail VARCHAR2(255);
r_fccih.hist_start_dt := p_old_last_update_date;
r_fccih.hist_end_dt := p_new_last_update_date;
r_fccih.hist_who := p_old_last_updated_by;
IGS_FI_FEE_CAT_CI_HT_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_CAT => r_fccih.FEE_CAT,
X_fee_cal_type => r_fccih.fee_cal_type,
X_fee_ci_sequence_number => r_fccih.fee_ci_sequence_number,
X_hist_start_dt => r_fccih.hist_start_dt,
X_hist_end_dt => r_fccih.hist_end_dt,
X_hist_who => r_fccih.hist_who,
X_fee_cat_ci_status => r_fccih.fee_cat_ci_status,
X_start_dt_alias => r_fccih.start_dt_alias,
X_start_dai_sequence_number => r_fccih.start_dai_sequence_number,
X_end_dt_alias => r_fccih.end_dt_alias,
X_end_dai_sequence_number => r_fccih.end_dai_sequence_number,
X_retro_dt_alias => r_fccih.retro_dt_alias,
X_retro_dai_sequence_number => r_fccih.retro_dai_sequence_number,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_F_CAT_FEE_LBL_ALL.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_F_CAT_FEE_LBL_ALL.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_F_CAT_FEE_LBL_ALL.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_F_CAT_FEE_LBL_ALL.last_update_date%TYPE )
AS
/*----------------------------------------------------------------------------
|| Created By :
|| Created On :
|| Purpose :
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| vvutukur 19-Jul-2002 Bug#2425767.Removed parameters p_new_payment_hierarchy_rank,
|| p_old_payment_hierarchy_rank and its references(from if condition and
|| from call IGS_FI_F_CAT_F_LBL_H_PKG.INSERT_ROW).
----------------------------------------------------------------------------*/
gv_other_detail VARCHAR2(255);
r_fcflh.hist_start_dt := p_old_last_update_date;
r_fcflh.hist_end_dt := p_new_last_update_date;
r_fcflh.hist_who := p_old_last_updated_by;
IGS_FI_F_CAT_F_LBL_H_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_CAT => r_fcflh.FEE_CAT,
X_fee_cal_type => r_fcflh.fee_cal_type,
X_fee_ci_sequence_number => r_fcflh.fee_ci_sequence_number,
X_FEE_TYPE => r_fcflh.FEE_TYPE,
X_hist_start_dt => r_fcflh.hist_start_dt,
X_hist_end_dt => r_fcflh.hist_end_dt,
X_hist_who => r_fcflh.hist_who,
X_fee_liability_status => r_fcflh.fee_liability_status,
X_start_dt_alias => r_fcflh.start_dt_alias,
X_start_dai_sequence_number => r_fcflh.start_dai_sequence_number,
X_s_chg_method_type => r_fcflh.s_chg_method_type,
X_rul_sequence_number => r_fcflh.rul_sequence_number,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_FEE_RET_SCHD.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_FEE_RET_SCHD.last_update_date%TYPE )
AS
/*----------------------------------------------------------------------------
|| Created By :
|| Created On :
|| Purpose :
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| vvutukur 19-Jul-2002 Bug#2425767.removed parameter p_new_deduction_amount,p_old_deduction_amount
|| and its references(if condition and from call IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW).
----------------------------------------------------------------------------*/
gv_other_detail VARCHAR2(255);
-- Due to which it will result in unique key voilation and record will not get insert into history table.
--IF p_new_schedule_number <> p_old_schedule_number THEN
r_frtnsh.schedule_number := p_old_schedule_number;
r_frtnsh.hist_start_dt := p_old_last_update_date;
r_frtnsh.hist_end_dt := p_new_last_update_date;
r_frtnsh.hist_who := p_old_last_updated_by;
IGS_FI_F_RET_SCHD_HT_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_fee_cal_type => r_frtnsh.fee_cal_type,
X_fee_ci_sequence_number => r_frtnsh.fee_ci_sequence_number,
X_s_relation_type => r_frtnsh.s_relation_type,
X_sequence_number => r_frtnsh.sequence_number,
X_hist_start_dt => r_frtnsh.hist_start_dt,
X_hist_end_dt => r_frtnsh.hist_end_dt,
X_hist_who => r_frtnsh.hist_who,
X_FEE_TYPE => r_frtnsh.FEE_TYPE,
X_FEE_CAT => r_frtnsh.FEE_CAT,
X_schedule_number => r_frtnsh.schedule_number,
X_DT_ALIAS => r_frtnsh.DT_ALIAS,
X_dai_sequence_number => r_frtnsh.dai_sequence_number,
X_retention_percentage => r_frtnsh.retention_percentage,
X_retention_amount => r_frtnsh.retention_amount,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_F_TYP_CA_INST_ALL.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_F_TYP_CA_INST_ALL.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_F_TYP_CA_INST_ALL.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_F_TYP_CA_INST_ALL.last_update_date%TYPE,
-- Added by Nishikant , to include the following new fields for enhancement bug#1851586
p_new_initial_default_amount IN IGS_FI_F_TYP_CA_INST_ALL.initial_default_amount%TYPE,
p_old_initial_default_amount IN IGS_FI_F_TYP_CA_INST_ALL.initial_default_amount%TYPE,
--Added by svuppala,as a part of bug:4295379 New field "nonzero_billable_cp_flag"
p_new_nonzero_billable_cp_flag IN IGS_FI_F_TYP_CA_INST_ALL.nonzero_billable_cp_flag%TYPE,
p_old_nonzero_billable_cp_flag IN IGS_FI_F_TYP_CA_INST_ALL.nonzero_billable_cp_flag%TYPE)
AS
/*----------------------------------------------------------------------------
|| Created By :
|| Created On :
|| Purpose :
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| svuppala 13-Apr-2005 Bug 4297359 - ER REGISTRATION FEE ISSUE - ASSESSED TO STUDENTS WITH NO LOAD
|| Added new field NONZERO_BILLABLE_CP_FLAG in IGS_FI_FEE_TYPE_CI_H_ALL
|| vvutukur 19-Jul-2002 Bug#2425767.Removed parameters p_new_payment_hierarchy_rank,
|| p_old_payment_hierarchy_rank and its references(from if condition and
|| from call to IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW.
----------------------------------------------------------------------------*/
gv_other_detail VARCHAR2(255);
r_ftcih.hist_start_dt := p_old_last_update_date;
r_ftcih.hist_end_dt := p_new_last_update_date;
r_ftcih.hist_who := p_old_last_updated_by;
IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_TYPE => r_ftcih.FEE_TYPE,
X_fee_cal_type => r_ftcih.fee_cal_type,
X_fee_ci_sequence_number => r_ftcih.fee_ci_sequence_number,
X_hist_start_dt => r_ftcih.hist_start_dt,
X_hist_end_dt => r_ftcih.hist_end_dt,
X_hist_who => r_ftcih.hist_who,
X_fee_type_ci_status => r_ftcih.fee_type_ci_status,
X_start_dt_alias => r_ftcih.start_dt_alias,
X_start_dai_sequence_number => r_ftcih.start_dai_sequence_number,
X_end_dt_alias => r_ftcih.retro_dt_alias,
X_end_dai_sequence_number => r_ftcih.retro_dai_sequence_number,
X_retro_dt_alias => r_ftcih.retro_dt_alias,
X_retro_dai_sequence_number => r_ftcih.retro_dai_sequence_number,
X_s_chg_method_type => r_ftcih.s_chg_method_type,
X_rul_sequence_number => r_ftcih.rul_sequence_number,
-- Added by Nishikant , to include the following new field for enhancement bug#1851586
X_initial_default_amount => r_ftcih.initial_default_amount,
X_MODE => 'R',
x_org_id => l_n_org_id,
--Added by svuppala,as a part of bug:4295379 New field "nonzero_billable_cp_flag"
x_nonzero_billable_cp_flag => r_ftcih.nonzero_billable_cp_flag);
p_new_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_FEE_TYPE_ALL.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_FEE_TYPE_ALL.last_update_date%TYPE ,
p_new_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE ,
p_old_comments IN IGS_FI_FEE_TYPE_ALL.comments%TYPE )
AS
/*----------------------------------------------------------------------------
|| Created By :
|| Created On :
|| Purpose :
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| (reverse chronological order - newest change first)
|| shtatiko 30-MAY-2003 Enh# 2831582, Added new column designated_payment_flag.
|| vvutukur 13-Sep-2002 Enh#2564643.Removed parameters p_new_subaccount_id,p_old_subaccount_id.
|| and related validation,also removed the parameter P_SUBACCOUNT_ID
|| from the call to IGS_FI_FEE_TYPE_HIST_PKG.INSERT_ROW.
----------------------------------------------------------------------------*/
gv_other_detail VARCHAR2(255);
r_fth.hist_start_dt := p_old_last_update_date;
r_fth.hist_end_dt := p_new_last_update_date;
r_fth.hist_who := p_old_last_updated_by;
IGS_FI_FEE_TYPE_HIST_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_TYPE => r_fth.FEE_TYPE,
X_hist_start_dt => r_fth.hist_start_dt,
X_hist_end_dt => r_fth.hist_end_dt,
X_hist_who => r_fth.hist_who,
X_s_fee_type => r_fth.s_fee_type,
X_s_fee_trigger_cat => r_fth.s_fee_trigger_cat,
X_description => r_fth.description,
X_optional_payment_ind => r_fth.optional_payment_ind,
X_closed_ind => r_fth.closed_ind,
X_comments => r_fth.comments,
X_Fee_class => r_fth.fee_class,
x_designated_payment_flag => r_fth.designated_payment_flag,
X_MODE => 'R',
x_org_id => l_n_org_id);
p_new_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
p_old_last_updated_by IN IGS_FI_UNIT_FEE_TRG.last_updated_by%TYPE ,
p_new_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE ,
p_old_last_update_date IN IGS_FI_UNIT_FEE_TRG.last_update_date%TYPE )
AS
gv_other_detail VARCHAR2(255);
r_ufth.hist_start_dt := p_old_last_update_date;
r_ufth.hist_end_dt := p_new_last_update_date;
r_ufth.hist_who := p_old_last_updated_by;
IGS_FI_UNIT_FEE_TR_H_PKG.INSERT_ROW(
X_ROWID => X_ROWID,
X_FEE_CAT => r_ufth.FEE_CAT,
X_fee_cal_type => r_ufth.fee_cal_type,
X_fee_ci_sequence_number => r_ufth.fee_ci_sequence_number,
X_FEE_TYPE => r_ufth.FEE_TYPE,
X_unit_cd => r_ufth.unit_cd,
X_sequence_number => r_ufth.sequence_number,
X_hist_start_dt => r_ufth.hist_start_dt,
X_hist_end_dt => r_ufth.hist_end_dt,
X_hist_who => r_ufth.hist_who,
X_version_number => r_ufth.version_number,
X_CAL_TYPE => r_ufth.CAL_TYPE,
X_ci_sequence_number => r_ufth.ci_sequence_number,
X_location_cd => r_ufth.location_cd,
X_UNIT_CLASS => r_ufth.UNIT_CLASS,
X_create_dt => r_ufth.create_dt,
X_fee_trigger_group_number => r_ufth.fee_trigger_group_number,
X_MODE => 'R',
x_org_id => l_n_org_id);
SELECT 'X'
FROM gl_code_combinations
WHERE code_combination_id = cp_ccid
AND chart_of_accounts_id = igs_fi_gen_007.get_coa_id;