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.

[Home] [Help]

APPS.IGS_FI_GEN_002 dependencies on IGS_FI_FEE_AS_RT

Line 33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,

29: --vvutukur 11-Jan-2002 added new columns in finp_ins_ft_hist
30: -- procedure as part of Bug 2175865
31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: PROCEDURE finp_ins_cfar_hist(
33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

Line 34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,

30: -- procedure as part of Bug 2175865
31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: PROCEDURE finp_ins_cfar_hist(
33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

Line 35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,

31: /* Obseleted the procedure finp_ins_fe_hist( as part of bug 2126091 as this is no longer used -sykrishn 29112001 */
32: PROCEDURE finp_ins_cfar_hist(
33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

Line 36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,

32: PROCEDURE finp_ins_cfar_hist(
33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

Line 37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

33: p_person_id IN IGS_FI_FEE_AS_RT.person_id%TYPE ,
34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,

Line 38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,

34: p_course_cd IN IGS_FI_FEE_AS_RT.course_cd%TYPE ,
35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
42: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,

Line 39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

35: p_fee_type IN IGS_FI_FEE_AS_RT.FEE_TYPE%TYPE ,
36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
42: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,

Line 40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,

36: p_start_dt IN IGS_FI_FEE_AS_RT.start_dt%TYPE ,
37: p_new_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
38: p_old_end_dt IN IGS_FI_FEE_AS_RT.end_dt%TYPE ,
39: p_new_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
40: p_old_location_cd IN IGS_FI_FEE_AS_RT.location_cd%TYPE ,
41: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
42: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
44: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,

Line 45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

41: p_new_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
42: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
44: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

Line 46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,

42: p_old_attendance_type IN IGS_EN_ATD_TYPE_ALL.ATTENDANCE_TYPE%TYPE ,
43: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
44: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

Line 47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

43: p_new_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
44: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,

Line 48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,

44: p_old_attendance_mode IN IGS_EN_ATD_MODE_ALL.ATTENDANCE_MODE%TYPE ,
45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE

Line 49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

45: p_new_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
53: )

Line 50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,

46: p_old_chg_rate IN IGS_FI_FEE_AS_RT.chg_rate%TYPE ,
47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
53: )
54: AS

Line 51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,

47: p_new_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
53: )
54: AS
55: gv_other_detail VARCHAR2(255);

Line 52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE

48: p_old_lower_nrml_rate_ovrd_ind IN IGS_FI_FEE_AS_RT.lower_nrml_rate_ovrd_ind%TYPE ,
49: p_new_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
50: p_old_last_updated_by IN IGS_FI_FEE_AS_RT.last_updated_by%TYPE ,
51: p_new_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE ,
52: p_old_last_update_date IN IGS_FI_FEE_AS_RT.last_update_date%TYPE
53: )
54: AS
55: gv_other_detail VARCHAR2(255);
56: BEGIN

Line 59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;

55: gv_other_detail VARCHAR2(255);
56: BEGIN
57: DECLARE
58: X_ROWID VARCHAR2(25);
59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.

Line 61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;

57: DECLARE
58: X_ROWID VARCHAR2(25);
59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.

Line 63: -- Create a history for a IGS_FI_FEE_AS_RT record.

59: r_cfarh IGS_FI_FEE_AS_RT_HT%ROWTYPE;
60: v_create_history BOOLEAN := FALSE;
61: l_n_org_id IGS_FI_FEE_AS_RT_HT.org_id%TYPE := igs_ge_gen_003.get_org_id;
62: BEGIN
63: -- Create a history for a IGS_FI_FEE_AS_RT record.
64: -- Check if any of the non-primary key fields have been changed
65: -- and set the flag v_create_history to indicate so.
66: IF NVL(p_new_end_dt, igs_ge_date.igsdate('1000/01/01')) <>
67: NVL(p_old_end_dt, igs_ge_date.igsdate('1000/01/01')) THEN

Line 102: IGS_FI_FEE_AS_RT_HT_PKG.INSERT_ROW(

98: r_cfarh.start_dt := p_start_dt;
99: r_cfarh.hist_start_dt := p_old_last_update_date;
100: r_cfarh.hist_end_dt := p_new_last_update_date;
101: r_cfarh.hist_who := p_old_last_updated_by;
102: IGS_FI_FEE_AS_RT_HT_PKG.INSERT_ROW(
103: X_ROWID => X_ROWID,
104: X_person_id => r_cfarh.person_id,
105: X_course_cd => r_cfarh.course_cd,
106: X_FEE_TYPE => r_cfarh.FEE_TYPE,

Line 391: r_farh IGS_FI_FEE_AS_RT_H_ALL%ROWTYPE;

387: gv_other_detail VARCHAR2(255);
388: BEGIN
389: DECLARE
390: x_rowid VARCHAR2(25);
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.

Line 393: l_n_org_id IGS_FI_FEE_AS_RT_H_ALL.org_id%TYPE := igs_ge_gen_003.get_org_id;

389: DECLARE
390: x_rowid VARCHAR2(25);
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.

Line 516: igs_fi_fee_as_rt_h_pkg.insert_row(

512: r_farh.hist_start_dt := p_old_last_update_date;
513: r_farh.hist_end_dt := p_new_last_update_date;
514: r_farh.hist_who := p_old_last_updated_by;
515:
516: igs_fi_fee_as_rt_h_pkg.insert_row(
517: x_rowid => x_rowid,
518: x_fee_type => r_farh.fee_type,
519: x_fee_cal_type => r_farh.fee_cal_type,
520: x_fee_ci_sequence_number => r_farh.fee_ci_sequence_number,