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_PS_FEE_TRG

Line 131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,

127: APP_EXCEPTION.RAISE_EXCEPTION;
128: END FINP_INS_CFAR_HIST;
129: --
130: PROCEDURE finp_ins_cft_hist(
131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,

Line 132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,

128: END FINP_INS_CFAR_HIST;
129: --
130: PROCEDURE finp_ins_cft_hist(
131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,

Line 133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,

129: --
130: PROCEDURE finp_ins_cft_hist(
131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

Line 134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,

130: PROCEDURE finp_ins_cft_hist(
131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

Line 135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,

131: p_fee_cat IN IGS_PS_FEE_TRG.FEE_CAT%TYPE ,
132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

Line 136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,

132: p_fee_cal_type IN IGS_PS_FEE_TRG.fee_cal_type%TYPE ,
133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

Line 137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

133: p_fee_ci_sequence_number IN IGS_PS_FEE_TRG.fee_ci_sequence_number%TYPE ,
134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

Line 138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,

134: p_fee_type IN IGS_PS_FEE_TRG.FEE_TYPE%TYPE ,
135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

Line 139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

135: p_course_cd IN IGS_PS_FEE_TRG.course_cd%TYPE ,
136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

Line 140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,

136: p_sequence_number IN IGS_PS_FEE_TRG.sequence_number%TYPE ,
137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

Line 141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

137: p_new_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

Line 142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,

138: p_old_version_number IN IGS_PS_FEE_TRG.version_number%TYPE ,
139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

Line 143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

139: p_new_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

Line 144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,

140: p_old_cal_type IN IGS_PS_FEE_TRG.CAL_TYPE%TYPE ,
141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

Line 145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

141: p_new_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,

Line 146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,

142: p_old_location_cd IN IGS_PS_FEE_TRG.location_cd%TYPE ,
143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,

Line 147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

143: p_new_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

Line 148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,

144: p_old_attendance_mode IN IGS_PS_FEE_TRG.ATTENDANCE_MODE%TYPE ,
145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

Line 149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,

145: p_new_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,

Line 150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,

146: p_old_attendance_type IN IGS_PS_FEE_TRG.ATTENDANCE_TYPE%TYPE ,
147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )

Line 151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

147: p_new_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )
155: AS

Line 152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,

148: p_old_create_dt IN IGS_PS_FEE_TRG.create_dt%TYPE ,
149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )
155: AS
156: gv_other_detail VARCHAR2(255);

Line 153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,

149: p_new_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )
155: AS
156: gv_other_detail VARCHAR2(255);
157: BEGIN

Line 154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )

150: p_old_fee_trigger_group_number IN IGS_PS_FEE_TRG.fee_trigger_group_number%TYPE,
151: p_new_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
152: p_old_last_updated_by IN IGS_PS_FEE_TRG.last_updated_by%TYPE ,
153: p_new_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE ,
154: p_old_last_update_date IN IGS_PS_FEE_TRG.last_update_date%TYPE )
155: AS
156: gv_other_detail VARCHAR2(255);
157: BEGIN
158: DECLARE

Line 160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;

156: gv_other_detail VARCHAR2(255);
157: BEGIN
158: DECLARE
159: X_ROWID VARCHAR2(25);
160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.

Line 162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;

158: DECLARE
159: X_ROWID VARCHAR2(25);
160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.
165: -- Check if any of the non-primary key fields have been changed
166: -- and set the flag v_create_history to indicate so.

Line 164: -- Create a history for a IGS_PS_FEE_TRG record.

160: r_cfth IGS_PS_FEE_TRG_HIST%ROWTYPE;
161: v_create_history BOOLEAN := FALSE;
162: l_n_org_id IGS_PS_FEE_TRG_HIST.org_id%TYPE := igs_ge_gen_003.get_org_id;
163: BEGIN
164: -- Create a history for a IGS_PS_FEE_TRG record.
165: -- Check if any of the non-primary key fields have been changed
166: -- and set the flag v_create_history to indicate so.
167: IF NVL(p_new_version_number, 0) <> NVL(p_old_version_number, 0) THEN
168: r_cfth.version_number := p_old_version_number;

Line 209: IGS_PS_FEE_TRG_HIST_PKG.INSERT_ROW(

205: r_cfth.sequence_number := p_sequence_number;
206: r_cfth.hist_start_dt := p_old_last_update_date;
207: r_cfth.hist_end_dt := p_new_last_update_date;
208: r_cfth.hist_who := p_old_last_updated_by;
209: IGS_PS_FEE_TRG_HIST_PKG.INSERT_ROW(
210: X_ROWID => X_ROWID,
211: X_FEE_CAT => r_cfth.FEE_CAT,
212: X_fee_cal_type => r_cfth.fee_cal_type,
213: X_fee_ci_sequence_number => r_cfth.fee_ci_sequence_number,