APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_TYPE_CI_H

Line 9: -- IGS_FI_FEE_TYPE_CI_H_ALL

5: --svuppala 31-MAY-2005 Enh 3442712: Added Unit Program Type Level, Unit Mode, Unit Class, Unit Code,
6: -- Unit Version and Unit Level
7: -- svuppala 13-Apr-2005 Bug 4297359 - ER REGISTRATION FEE ISSUE - ASSESSED TO STUDENTS WITH NO LOAD
8: -- Modifications to reflect the data model changes (NONZERO_BILLABLE_CP_FLAG) in
9: -- IGS_FI_FEE_TYPE_CI_H_ALL
10: --pathipat 09-Sep-2003 Enh 3108052 - Add Unit Sets to 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

Line 931: || Added new field NONZERO_BILLABLE_CP_FLAG in IGS_FI_FEE_TYPE_CI_H_ALL

927: || Change History :
928: || Who When What
929: || (reverse chronological order - newest change first)
930: || svuppala 13-Apr-2005 Bug 4297359 - ER REGISTRATION FEE ISSUE - ASSESSED TO STUDENTS WITH NO LOAD
931: || Added new field NONZERO_BILLABLE_CP_FLAG in IGS_FI_FEE_TYPE_CI_H_ALL
932: || vvutukur 19-Jul-2002 Bug#2425767.Removed parameters p_new_payment_hierarchy_rank,
933: || p_old_payment_hierarchy_rank and its references(from if condition and
934: || from call to IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW.
935: ----------------------------------------------------------------------------*/

Line 934: || from call to IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW.

930: || svuppala 13-Apr-2005 Bug 4297359 - ER REGISTRATION FEE ISSUE - ASSESSED TO STUDENTS WITH NO LOAD
931: || Added new field NONZERO_BILLABLE_CP_FLAG in IGS_FI_FEE_TYPE_CI_H_ALL
932: || vvutukur 19-Jul-2002 Bug#2425767.Removed parameters p_new_payment_hierarchy_rank,
933: || p_old_payment_hierarchy_rank and its references(from if condition and
934: || from call to IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW.
935: ----------------------------------------------------------------------------*/
936: gv_other_detail VARCHAR2(255);
937: BEGIN
938: DECLARE

Line 940: r_ftcih IGS_FI_FEE_TYPE_CI_H%ROWTYPE;

936: gv_other_detail VARCHAR2(255);
937: BEGIN
938: DECLARE
939: X_ROWID VARCHAR2(25);
940: r_ftcih IGS_FI_FEE_TYPE_CI_H%ROWTYPE;
941: v_create_history BOOLEAN := FALSE;
942: l_n_org_id IGS_FI_FEE_TYPE_CI_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
943: BEGIN
944: -- Check if any of the non-primary key fields have been changed

Line 942: l_n_org_id IGS_FI_FEE_TYPE_CI_H.org_id%TYPE := igs_ge_gen_003.get_org_id;

938: DECLARE
939: X_ROWID VARCHAR2(25);
940: r_ftcih IGS_FI_FEE_TYPE_CI_H%ROWTYPE;
941: v_create_history BOOLEAN := FALSE;
942: l_n_org_id IGS_FI_FEE_TYPE_CI_H.org_id%TYPE := igs_ge_gen_003.get_org_id;
943: BEGIN
944: -- Check if any of the non-primary key fields have been changed
945: -- and set the flag v_create_history to indicate so.
946: IF p_new_fee_type_ci_status <> p_old_fee_type_ci_status THEN

Line 1004: IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW(

1000: r_ftcih.hist_start_dt := p_old_last_update_date;
1001: r_ftcih.hist_end_dt := p_new_last_update_date;
1002: r_ftcih.hist_who := p_old_last_updated_by;
1003: r_ftcih.fee_type_ci_status := p_old_fee_type_ci_status;
1004: IGS_FI_FEE_TYPE_CI_H_PKG.INSERT_ROW(
1005: X_ROWID => X_ROWID,
1006: X_FEE_TYPE => r_ftcih.FEE_TYPE,
1007: X_fee_cal_type => r_ftcih.fee_cal_type,
1008: X_fee_ci_sequence_number => r_ftcih.fee_ci_sequence_number,