[Home] [Help]
41: 5 new Unit Level Attributes in insert_row method
42: gurprsin 03-Jun-2005 Enh# 3442712 - Modified TBH calls to table IGS_FI_FTCI_ACCTS to include 4 new Unit Level Attributes i.e. in insert_row method
43: svuppala 11-Mar-2004 Bug 4224379 - Changed the function 'finp_ins_roll_uft'.
44: New cursor 'c_alt_cd' is created to get "Alternate code" from
45: igs_ca_inst_all and to send as a token in IGS_FI_ROLLOVER_UFT_ERROR.
46: Added an EXCEPTION to log a message in case of rolling over failure.
47: agairola 13-Sep-2004 Bug 3316063 - Retention Enhancements Build
48: pathipat 12-Jul-2004 Bug 3759552 - Added code to roll over Fee Trigger groups, Unit Fee Triggers and Unit Set Fee Triggers
49: Added functions for the same and corresponding calls in finp_ins_roll_fcfl().
124:
125: g_v_gl_installed igs_fi_control_all.rec_installed%TYPE;
126: g_n_segment_num fnd_id_flex_segments.segment_num%TYPE := NULL;
127: cst_warning CONSTANT VARCHAR2(7) := 'WARNING';
128: g_v_alternate_code igs_ca_inst_all.alternate_code%TYPE := NULL;
129:
130: -- Routine to rollover fee type calendar instances between cal instances
131: FUNCTION finp_ins_roll_ftci(
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
130: -- Routine to rollover fee type calendar instances between cal instances
131: FUNCTION finp_ins_roll_ftci(
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
131: FUNCTION finp_ins_roll_ftci(
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
139: p_message_name OUT NOCOPY VARCHAR2 ,
132: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
139: p_message_name OUT NOCOPY VARCHAR2 ,
140: p_message_warning OUT NOCOPY VARCHAR2 )
133: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
134: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
135: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
136: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
137: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
138: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
139: p_message_name OUT NOCOPY VARCHAR2 ,
140: p_message_warning OUT NOCOPY VARCHAR2 )
141: RETURN BOOLEAN;
142: --
143: -- Routine to rollover fee cat calendar instances between cal instances
144: FUNCTION finp_ins_roll_fcci(
145: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
146: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
147: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
143: -- Routine to rollover fee cat calendar instances between cal instances
144: FUNCTION finp_ins_roll_fcci(
145: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
146: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
147: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
144: FUNCTION finp_ins_roll_fcci(
145: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
146: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
147: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
152: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
145: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
146: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
147: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
148: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
149: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
150: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
151: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
152: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
153: p_message_name OUT NOCOPY VARCHAR2 ,
155: RETURN BOOLEAN;
156: --
157: -- Routine to rollover fee retention schedules between cal instances
158: FUNCTION finp_ins_roll_frtns(
159: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
160: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
161: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
162: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
163: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
156: --
157: -- Routine to rollover fee retention schedules between cal instances
158: FUNCTION finp_ins_roll_frtns(
159: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
160: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
161: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
162: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
163: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
164: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
157: -- Routine to rollover fee retention schedules between cal instances
158: FUNCTION finp_ins_roll_frtns(
159: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
160: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
161: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
162: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
163: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
164: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
165: p_fee_cat IN IGS_FI_FEE_RET_SCHD.fee_cat%TYPE ,
158: FUNCTION finp_ins_roll_frtns(
159: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
160: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
161: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
162: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
163: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
164: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
165: p_fee_cat IN IGS_FI_FEE_RET_SCHD.fee_cat%TYPE ,
166: p_message_name OUT NOCOPY VARCHAR2 )
171: --
172: -- Routine to rollover fee cat fee liabilities between cal instances
173: FUNCTION finp_ins_roll_fcfl(
174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
172: -- Routine to rollover fee cat fee liabilities between cal instances
173: FUNCTION finp_ins_roll_fcfl(
174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
173: FUNCTION finp_ins_roll_fcfl(
174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
181: p_message_name OUT NOCOPY VARCHAR2 ,
174: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
175: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
176: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
177: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
178: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
179: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
180: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
181: p_message_name OUT NOCOPY VARCHAR2 ,
182: p_message_warning OUT NOCOPY VARCHAR2 )
189:
190: -- Routine to rollover fee assessment rates between cal instances
191: FUNCTION finp_ins_roll_far(
192: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
193: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
194: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
195: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
196: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
197: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
190: -- Routine to rollover fee assessment rates between cal instances
191: FUNCTION finp_ins_roll_far(
192: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
193: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
194: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
195: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
196: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
197: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
198: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
191: FUNCTION finp_ins_roll_far(
192: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
193: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
194: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
195: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
196: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
197: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
198: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
199: p_message_name OUT NOCOPY VARCHAR2 )
192: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
193: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
194: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
195: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
196: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
197: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
198: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
199: p_message_name OUT NOCOPY VARCHAR2 )
200: RETURN BOOLEAN;
201: --
202: -- Routine to rollover elements ranges between cal instances
203: FUNCTION finp_ins_roll_er(
204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
202: -- Routine to rollover elements ranges between cal instances
203: FUNCTION finp_ins_roll_er(
204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
203: FUNCTION finp_ins_roll_er(
204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
211: p_message_name OUT NOCOPY VARCHAR2 )
204: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
205: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
206: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
207: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
208: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
209: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
210: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
211: p_message_name OUT NOCOPY VARCHAR2 )
212: RETURN BOOLEAN;
212: RETURN BOOLEAN;
213:
214: -- Function to roll over Fee Trigger Groups
215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
213:
214: -- Function to roll over Fee Trigger Groups
215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
221: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
214: -- Function to roll over Fee Trigger Groups
215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
221: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
222:
215: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
216: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
217: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
218: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
219: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
220: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
221: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
222:
223: --
223: --
224: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
225: FUNCTION finp_ins_roll_ctft(
226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
224: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
225: FUNCTION finp_ins_roll_ctft(
226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
232: p_message_name OUT NOCOPY VARCHAR2 )
225: FUNCTION finp_ins_roll_ctft(
226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN;
226: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
227: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
228: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
229: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
230: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
231: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
232: p_message_name OUT NOCOPY VARCHAR2 )
233: RETURN BOOLEAN;
234: --
234: --
235: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
236: FUNCTION finp_ins_roll_cgft(
237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
235: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
236: FUNCTION finp_ins_roll_cgft(
237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
243: p_message_name OUT NOCOPY VARCHAR2 )
236: FUNCTION finp_ins_roll_cgft(
237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
243: p_message_name OUT NOCOPY VARCHAR2 )
244: RETURN BOOLEAN;
237: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
238: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
239: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
240: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
241: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
243: p_message_name OUT NOCOPY VARCHAR2 )
244: RETURN BOOLEAN;
245: --
245: --
246: -- Routine to rollover IGS_PS_COURSE fee triggers between cal instances
247: FUNCTION finp_ins_roll_cft(
248: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
249: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
250: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
251: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
252: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
253: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
246: -- Routine to rollover IGS_PS_COURSE fee triggers between cal instances
247: FUNCTION finp_ins_roll_cft(
248: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
249: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
250: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
251: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
252: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
253: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
254: p_message_name OUT NOCOPY VARCHAR2 )
247: FUNCTION finp_ins_roll_cft(
248: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
249: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
250: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
251: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
252: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
253: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
254: p_message_name OUT NOCOPY VARCHAR2 )
255: RETURN BOOLEAN;
248: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
249: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
250: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
251: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
252: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
253: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
254: p_message_name OUT NOCOPY VARCHAR2 )
255: RETURN BOOLEAN;
256:
255: RETURN BOOLEAN;
256:
257: -- Function to roll over Unit Fee Triggers between Calendar Instances
258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
256:
257: -- Function to roll over Unit Fee Triggers between Calendar Instances
258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
264: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
257: -- Function to roll over Unit Fee Triggers between Calendar Instances
258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
264: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
265:
258: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
259: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
260: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
261: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
262: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
263: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
264: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
265:
266: -- Function to roll over Unit Set Fee Triggers between Calendar Instances
264: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
265:
266: -- Function to roll over Unit Set Fee Triggers between Calendar Instances
267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
265:
266: -- Function to roll over Unit Set Fee Triggers between Calendar Instances
267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
273: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
266: -- Function to roll over Unit Set Fee Triggers between Calendar Instances
267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
273: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
274:
267: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
268: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
269: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
270: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
271: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
272: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
273: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN;
274:
275: --
287: --To rollover revenue segments over for Fee Type Calendar Instances occurs.
288: --
289: FUNCTION finp_ins_roll_revseg(
290: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
291: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
292: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
293: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
294: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
295: p_message_name OUT NOCOPY VARCHAR2
288: --
289: FUNCTION finp_ins_roll_revseg(
290: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
291: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
292: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
293: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
294: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
295: p_message_name OUT NOCOPY VARCHAR2
296: )
289: FUNCTION finp_ins_roll_revseg(
290: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
291: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
292: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
293: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
294: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
295: p_message_name OUT NOCOPY VARCHAR2
296: )
297: RETURN BOOLEAN;
290: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
291: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
292: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
293: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
294: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
295: p_message_name OUT NOCOPY VARCHAR2
296: )
297: RETURN BOOLEAN;
298:
299: -- To Rollover Account Table Attribute Records IF System Fee Type is OTHER or TUITION
300: -- This has been added as part of Enh# 2831572
301: FUNCTION finpl_ins_roll_over_ftci_accts (
302: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
303: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
304: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
305: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
306: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
307: ) RETURN BOOLEAN;
300: -- This has been added as part of Enh# 2831572
301: FUNCTION finpl_ins_roll_over_ftci_accts (
302: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
303: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
304: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
305: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
306: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
307: ) RETURN BOOLEAN;
308:
301: FUNCTION finpl_ins_roll_over_ftci_accts (
302: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
303: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
304: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
305: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
306: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
307: ) RETURN BOOLEAN;
308:
309: -- Forward declaration of the finp_ins_roll_tprs procedure
302: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
303: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
304: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
305: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
306: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
307: ) RETURN BOOLEAN;
308:
309: -- Forward declaration of the finp_ins_roll_tprs procedure
310: PROCEDURE finp_ins_roll_tprs(p_v_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
375: || System Option. If its value is NULL then this
376: || process cannot be executed.
377: ----------------------------------------------------------------------------*/
378: gv_other_detail VARCHAR2(255);
379: p_source_cal_type igs_ca_inst.cal_type%TYPE ;
380: p_source_sequence_number igs_ca_inst.sequence_number%TYPE ;
381: p_dest_cal_type igs_ca_inst.cal_type%TYPE ;
382: p_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
383: BEGIN
376: || process cannot be executed.
377: ----------------------------------------------------------------------------*/
378: gv_other_detail VARCHAR2(255);
379: p_source_cal_type igs_ca_inst.cal_type%TYPE ;
380: p_source_sequence_number igs_ca_inst.sequence_number%TYPE ;
381: p_dest_cal_type igs_ca_inst.cal_type%TYPE ;
382: p_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
383: BEGIN
384: --Block for Parameter Validation/Splitting of Parameters
377: ----------------------------------------------------------------------------*/
378: gv_other_detail VARCHAR2(255);
379: p_source_cal_type igs_ca_inst.cal_type%TYPE ;
380: p_source_sequence_number igs_ca_inst.sequence_number%TYPE ;
381: p_dest_cal_type igs_ca_inst.cal_type%TYPE ;
382: p_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
383: BEGIN
384: --Block for Parameter Validation/Splitting of Parameters
385:
378: gv_other_detail VARCHAR2(255);
379: p_source_cal_type igs_ca_inst.cal_type%TYPE ;
380: p_source_sequence_number igs_ca_inst.sequence_number%TYPE ;
381: p_dest_cal_type igs_ca_inst.cal_type%TYPE ;
382: p_dest_sequence_number igs_ca_inst.sequence_number%TYPE;
383: BEGIN
384: --Block for Parameter Validation/Splitting of Parameters
385:
386: igs_ge_gen_003.set_org_id(p_org_id);
421: DECLARE
422: v_message_name VARCHAR2(30);
423: v_message_warning VARCHAR2(30);
424: v_cal_type IGS_CA_TYPE.cal_type%TYPE;
425: v_prior_ci_sequence_number IGS_CA_INST.prior_ci_sequence_number%TYPE;
426: l_v_message_name fnd_new_messages.message_name%TYPE;
427: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
428:
429: CURSOR c_cat IS
431: FROM IGS_CA_TYPE cat
432: WHERE cat.cal_type = p_source_cal_type;
433: CURSOR c_ci IS
434: SELECT ci.prior_ci_sequence_number
435: FROM IGS_CA_INST ci
436: WHERE ci.cal_type = p_dest_cal_type AND
437: ci.sequence_number = p_dest_sequence_number;
438: FUNCTION finpl_chk_fss (
439: p_fee_structure_status IN IGS_FI_FEE_STR_STAT.fee_structure_status%TYPE,
469: END;
470: END finpl_chk_fss;
471: BEGIN
472: -- This function will control the rollover of all fee structure data underneath
473: -- a nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
474:
475: -- Check the value of Manage Accounts System Option value.
476: -- If its NULL then this process should error out by logging message.
477: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
643: -- Routine to rollover fee type calendar instances between cal instances
644: FUNCTION finp_ins_roll_ftci(
645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
644: FUNCTION finp_ins_roll_ftci(
645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
652: p_message_name OUT NOCOPY VARCHAR2 ,
645: p_fee_type IN IGS_FI_F_TYP_CA_INST.fee_type%TYPE ,
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
652: p_message_name OUT NOCOPY VARCHAR2 ,
653: p_message_warning OUT NOCOPY VARCHAR2 )
646: p_fee_cat IN IGS_FI_FEE_CAT.fee_cat%TYPE ,
647: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
648: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
649: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
650: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
651: p_fee_type_ci_status IN IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE ,
652: p_message_name OUT NOCOPY VARCHAR2 ,
653: p_message_warning OUT NOCOPY VARCHAR2 )
654: RETURN BOOLEAN AS
704: v_fee_cat IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE;
705: v_fee_type_ci_status IGS_FI_F_TYP_CA_INST.fee_type_ci_status%TYPE;
706: v_tmp_fee_type IGS_FI_F_TYP_CA_INST.fee_type%TYPE;
707: v_closed_ind IGS_FI_FEE_TYPE.closed_ind%TYPE;
708: v_sequence_number IGS_CA_INST.sequence_number%TYPE;
709: v_valid_dai BOOLEAN;
710: v_dummy IGS_CA_DA_INST.dt_alias%TYPE;
711: l_n_org_id IGS_FI_F_TYP_CA_INST.ORG_ID%type := igs_ge_gen_003.get_org_id;
712: l_rowid VARCHAR2(25);
789: l_b_status BOOLEAN;
790: l_v_retention_level_code igs_fi_f_typ_ca_inst.retention_level_code%TYPE;
791: BEGIN
792: -- This function will roll all IGS_FI_F_TYP_CA_INST records underneath a
793: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
794: -- It also controls the rollover of;
795: -- * fee_refund_schedule
796: -- * IGS_FI_FEE_RET_SCHD
797: -- * IGS_FI_FEE_ENCMB
797: -- * IGS_FI_FEE_ENCMB
798: -- * IGS_FI_CHG_MTH_APP
799: -- * IGS_FI_FEE_AS_RATE
800: -- * IGS_FI_ELM_RANGE
801: -- The assumption is being made that the "destination" IGS_CA_INST
802: -- is open and active - it is the responsibility of the calling routine
803: -- to check for this.
804: -- IGS_GE_NOTE: If some of the IGS_FI_F_TYP_CA_INST records already exist then
805: -- these may be updated IF the assiciated IGS_FI_ACC link has not been
1172: --
1173: -- Routine to rollover fee cat calendar instances between cal instances
1174: FUNCTION finp_ins_roll_fcci(
1175: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
1176: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1177: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1173: -- Routine to rollover fee cat calendar instances between cal instances
1174: FUNCTION finp_ins_roll_fcci(
1175: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
1176: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1177: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1174: FUNCTION finp_ins_roll_fcci(
1175: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
1176: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1177: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1182: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
1175: p_fee_cat IN IGS_FI_F_CAT_CA_INST.fee_cat%TYPE ,
1176: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1177: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1178: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1179: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1180: p_fee_cat_ci_status IN IGS_FI_F_CAT_CA_INST.fee_cat_ci_status%TYPE ,
1181: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1182: p_fee_type IN IGS_FI_FEE_TYPE.fee_type%TYPE ,
1183: p_message_name OUT NOCOPY VARCHAR2 ,
1263: cal_type = cp_cal_type AND
1264: ci_sequence_number = cp_ci_sequence_number;
1265: BEGIN
1266: -- This function will roll all IGS_FI_F_CAT_CA_INST records underneath a
1267: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
1268: -- It also controls the rollover of
1269: -- * fee_refund_schedule
1270: -- * IGS_FI_FEE_RET_SCHD
1271: -- * IGS_FI_FEE_ENCMB
1269: -- * fee_refund_schedule
1270: -- * IGS_FI_FEE_RET_SCHD
1271: -- * IGS_FI_FEE_ENCMB
1272: -- * IGS_FI_F_CAT_FEE_LBL
1273: -- The assumption is being made that the "destination" IGS_CA_INST
1274: -- is open and active - it is the responsibility of the calling routine
1275: -- to check for this.
1276: -- IGS_GE_NOTE: If some of the IGS_FI_F_CAT_CA_INST records already exist then
1277: -- these will remain unaltered.
1458: --
1459:
1460: -- Routine to rollover fee retention schedules between cal instances
1461: FUNCTION finp_ins_roll_frtns(
1462: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1463: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1464: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1465: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1466: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
1459:
1460: -- Routine to rollover fee retention schedules between cal instances
1461: FUNCTION finp_ins_roll_frtns(
1462: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1463: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1464: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1465: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1466: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
1467: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
1460: -- Routine to rollover fee retention schedules between cal instances
1461: FUNCTION finp_ins_roll_frtns(
1462: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1463: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1464: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1465: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1466: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
1467: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
1468: p_fee_cat IN IGS_FI_FEE_RET_SCHD.fee_cat%TYPE ,
1461: FUNCTION finp_ins_roll_frtns(
1462: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1463: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1464: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1465: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1466: p_relation_type IN IGS_FI_FEE_RET_SCHD.s_relation_type%TYPE ,
1467: p_fee_type IN IGS_FI_FEE_RET_SCHD.fee_type%TYPE ,
1468: p_fee_cat IN IGS_FI_FEE_RET_SCHD.fee_cat%TYPE ,
1469: p_message_name OUT NOCOPY VARCHAR2 )
1551: cal_type = cp_cal_type AND
1552: ci_sequence_number = cp_ci_sequence_number;
1553: BEGIN
1554: -- This function will roll all IGS_FI_FEE_RET_SCHD records underneath a
1555: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
1556: -- The assumption is being made that the "destination" IGS_CA_INST
1557: -- is open and active - it is the responsibility of the calling routine to
1558: -- check for this.
1559: -- IGS_GE_NOTE: If some of the IGS_FI_FEE_RET_SCHD records already exist then
1552: ci_sequence_number = cp_ci_sequence_number;
1553: BEGIN
1554: -- This function will roll all IGS_FI_FEE_RET_SCHD records underneath a
1555: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
1556: -- The assumption is being made that the "destination" IGS_CA_INST
1557: -- is open and active - it is the responsibility of the calling routine to
1558: -- check for this.
1559: -- IGS_GE_NOTE: If some of the IGS_FI_FEE_RET_SCHD records already exist then
1560: -- these will remain unaltered.
1695: --
1696: -- Routine to rollover fee cat fee liabilities between cal instances
1697: FUNCTION finp_ins_roll_fcfl(
1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1696: -- Routine to rollover fee cat fee liabilities between cal instances
1697: FUNCTION finp_ins_roll_fcfl(
1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1697: FUNCTION finp_ins_roll_fcfl(
1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1705: p_message_name OUT NOCOPY VARCHAR2 ,
1698: p_fee_cat IN IGS_FI_F_CAT_FEE_LBL.fee_cat%TYPE ,
1699: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1700: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1701: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
1702: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
1703: p_fee_type IN IGS_FI_F_CAT_FEE_LBL.fee_type%TYPE ,
1704: p_fee_liability_status IN IGS_FI_F_CAT_FEE_LBL.fee_liability_status%TYPE ,
1705: p_message_name OUT NOCOPY VARCHAR2 ,
1706: p_message_warning OUT NOCOPY VARCHAR2 )
1791: cal_type = cp_cal_type AND
1792: ci_sequence_number = cp_ci_sequence_number;
1793: BEGIN
1794: -- This function will roll all IGS_FI_F_CAT_FEE_LBL records underneath a
1795: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
1796: -- It also controls the rollovr of
1797: -- * fee_refund_schedule
1798: -- * IGS_FI_FEE_RET_SCHD
1799: -- * IGS_FI_FEE_ENCMB
1799: -- * IGS_FI_FEE_ENCMB
1800: -- * IGS_FI_CHG_MTH_APP
1801: -- * IGS_FI_FEE_AS_RATE
1802: -- * IGS_FI_ELM_RANGE
1803: -- The assumption is being made that the "destination" IGS_CA_INST
1804: -- is open and active - it is the responsibility of the calling routine
1805: -- to check for this.
1806: -- IGS_GE_NOTE: If some of the IGS_FI_F_CAT_FEE_LBL records already exist then
1807: -- these will remain unaltered.
2071: --
2072: -- Routine to rollover fee assessment rates between cal instances
2073: FUNCTION finp_ins_roll_far(
2074: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
2075: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2076: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2077: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2078: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2079: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
2072: -- Routine to rollover fee assessment rates between cal instances
2073: FUNCTION finp_ins_roll_far(
2074: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
2075: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2076: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2077: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2078: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2079: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
2080: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
2073: FUNCTION finp_ins_roll_far(
2074: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
2075: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2076: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2077: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2078: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2079: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
2080: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
2081: p_message_name OUT NOCOPY VARCHAR2 )
2074: p_fee_type IN IGS_FI_FEE_AS_RATE.fee_type%TYPE ,
2075: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2076: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2077: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2078: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2079: p_relation_type IN IGS_FI_FEE_AS_RATE.s_relation_type%TYPE ,
2080: p_fee_cat IN IGS_FI_FEE_AS_RATE.fee_cat%TYPE ,
2081: p_message_name OUT NOCOPY VARCHAR2 )
2082: RETURN BOOLEAN AS
2146: far.s_relation_type = p_relation_type AND
2147: far.rate_number = cp_rate_number;
2148: BEGIN
2149: -- This function will roll all IGS_FI_FEE_AS_RATE records underneath a
2150: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2151: -- The assumption is being made that the "destination" IGS_CA_INST
2152: -- is open and active - it is the responsibility of the calling routine to
2153: -- check for this.
2154: -- IGS_GE_NOTE: If some of the IGS_FI_FEE_AS_RATE records already exist then these will
2147: far.rate_number = cp_rate_number;
2148: BEGIN
2149: -- This function will roll all IGS_FI_FEE_AS_RATE records underneath a
2150: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2151: -- The assumption is being made that the "destination" IGS_CA_INST
2152: -- is open and active - it is the responsibility of the calling routine to
2153: -- check for this.
2154: -- IGS_GE_NOTE: If some of the IGS_FI_FEE_AS_RATE records already exist then these will
2155: -- remain unaltered.
2259: -- Routine to rollover elements ranges between cal instances
2260:
2261: FUNCTION finp_ins_roll_er(
2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2260:
2261: FUNCTION finp_ins_roll_er(
2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
2261: FUNCTION finp_ins_roll_er(
2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
2269: p_message_name OUT NOCOPY VARCHAR2 )
2262: p_fee_type IN IGS_FI_ELM_RANGE.fee_type%TYPE ,
2263: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2264: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2265: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2266: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2267: p_relation_type IN IGS_FI_ELM_RANGE.s_relation_type%TYPE ,
2268: p_fee_cat IN IGS_FI_ELM_RANGE.fee_cat%TYPE ,
2269: p_message_name OUT NOCOPY VARCHAR2 )
2270: RETURN BOOLEAN AS
2435:
2436: BEGIN
2437: -- This function will roll all IGS_FI_ELM_RANGE and associated
2438: -- IGS_FI_ELM_RANGE_RT records underneath a
2439: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2440: -- The assumption is being made that the "destination" IGS_CA_INST
2441: -- is open and active - it is the responsibility of the calling routine to
2442: -- check for this.
2443: -- IGS_GE_NOTE: If some of the elemets_range/IGS_FI_ELM_RANGE_RT records already
2436: BEGIN
2437: -- This function will roll all IGS_FI_ELM_RANGE and associated
2438: -- IGS_FI_ELM_RANGE_RT records underneath a
2439: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2440: -- The assumption is being made that the "destination" IGS_CA_INST
2441: -- is open and active - it is the responsibility of the calling routine to
2442: -- check for this.
2443: -- IGS_GE_NOTE: If some of the elemets_range/IGS_FI_ELM_RANGE_RT records already
2444: -- exist then these will remain unaltered.
2726: --
2727: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
2728: FUNCTION finp_ins_roll_ctft(
2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
2727: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
2728: FUNCTION finp_ins_roll_ctft(
2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
2735: p_message_name OUT NOCOPY VARCHAR2 )
2728: FUNCTION finp_ins_roll_ctft(
2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
2735: p_message_name OUT NOCOPY VARCHAR2 )
2736: RETURN BOOLEAN AS
2729: p_fee_cat IN IGS_PS_TYPE_FEE_TRG.fee_cat%TYPE ,
2730: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2731: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2732: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2733: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2734: p_fee_type IN IGS_PS_TYPE_FEE_TRG.fee_type%TYPE ,
2735: p_message_name OUT NOCOPY VARCHAR2 )
2736: RETURN BOOLEAN AS
2737: /*******************************************************************/
2769: ctft.COURSE_TYPE = cp_course_type;
2770: X_SYSDATE DATE;
2771: BEGIN
2772: -- This function will roll all IGS_PS_TYPE_FEE_TRG records underneath a
2773: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2774: -- The assumption is being made that the "destination" IGS_CA_INST
2775: -- is open and active - it is the responsibility of the calling routine to
2776: -- check for this.
2777: -- IGS_GE_NOTE: If some of the IGS_PS_TYPE_FEE_TRG records already exist then these
2770: X_SYSDATE DATE;
2771: BEGIN
2772: -- This function will roll all IGS_PS_TYPE_FEE_TRG records underneath a
2773: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2774: -- The assumption is being made that the "destination" IGS_CA_INST
2775: -- is open and active - it is the responsibility of the calling routine to
2776: -- check for this.
2777: -- IGS_GE_NOTE: If some of the IGS_PS_TYPE_FEE_TRG records already exist then these
2778: -- will remain unaltered.
2836: --
2837: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
2838: FUNCTION finp_ins_roll_cgft(
2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
2837: -- Routine to rollover IGS_PS_COURSE group fee triggers between cal instances
2838: FUNCTION finp_ins_roll_cgft(
2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
2845: p_message_name OUT NOCOPY VARCHAR2 )
2838: FUNCTION finp_ins_roll_cgft(
2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
2845: p_message_name OUT NOCOPY VARCHAR2 )
2846: RETURN BOOLEAN AS
2839: p_fee_cat IN IGS_PS_GRP_FEE_TRG.fee_cat%TYPE ,
2840: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2841: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2842: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2843: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2844: p_fee_type IN IGS_PS_GRP_FEE_TRG.fee_type%TYPE ,
2845: p_message_name OUT NOCOPY VARCHAR2 )
2846: RETURN BOOLEAN AS
2847: /*******************************************************************/
2879: cgft.course_group_cd = cp_course_group_cd;
2880: X_SYSDATE DATE;
2881: BEGIN
2882: -- This function will roll all IGS_PS_GRP_FEE_TRG records underneath a
2883: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2884: -- The assumption is being made that the "destination" IGS_CA_INST
2885: -- is open and active - it is the responsibility of the calling routine to
2886: -- check for this.
2887: -- IGS_GE_NOTE: If some of the IGS_PS_GRP_FEE_TRG records already exist then
2880: X_SYSDATE DATE;
2881: BEGIN
2882: -- This function will roll all IGS_PS_GRP_FEE_TRG records underneath a
2883: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
2884: -- The assumption is being made that the "destination" IGS_CA_INST
2885: -- is open and active - it is the responsibility of the calling routine to
2886: -- check for this.
2887: -- IGS_GE_NOTE: If some of the IGS_PS_GRP_FEE_TRG records already exist then
2888: -- these will remain unaltered.
2947: --
2948: -- Routine to rollover IGS_PS_COURSE fee triggers between cal instances
2949: FUNCTION finp_ins_roll_cft(
2950: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
2951: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2952: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2953: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2954: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2955: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
2948: -- Routine to rollover IGS_PS_COURSE fee triggers between cal instances
2949: FUNCTION finp_ins_roll_cft(
2950: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
2951: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2952: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2953: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2954: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2955: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
2956: p_message_name OUT NOCOPY VARCHAR2 )
2949: FUNCTION finp_ins_roll_cft(
2950: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
2951: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2952: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2953: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2954: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2955: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
2956: p_message_name OUT NOCOPY VARCHAR2 )
2957: RETURN BOOLEAN AS
2950: p_fee_cat IN IGS_PS_FEE_TRG.fee_cat%TYPE ,
2951: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2952: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2953: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE ,
2954: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
2955: p_fee_type IN IGS_PS_FEE_TRG.fee_type%TYPE ,
2956: p_message_name OUT NOCOPY VARCHAR2 )
2957: RETURN BOOLEAN AS
2958: /*******************************************************************/
3000: cft.course_cd = cp_course_cd AND
3001: cft.sequence_number = cp_sequence_number;
3002: BEGIN
3003: -- This function will roll all IGS_PS_FEE_TRG records underneath a
3004: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
3005: -- The assumption is being made that the "destination" IGS_CA_INST
3006: -- is open and active - it is the responsibility of the calling routine to
3007: -- check for this.
3008: -- IGS_GE_NOTE: If some of the IGS_PS_FEE_TRG records already exist then these will
3001: cft.sequence_number = cp_sequence_number;
3002: BEGIN
3003: -- This function will roll all IGS_PS_FEE_TRG records underneath a
3004: -- nominated IGS_CA_INST to beneath another nominated IGS_CA_INST.
3005: -- The assumption is being made that the "destination" IGS_CA_INST
3006: -- is open and active - it is the responsibility of the calling routine to
3007: -- check for this.
3008: -- IGS_GE_NOTE: If some of the IGS_PS_FEE_TRG records already exist then these will
3009: -- remain unaltered.
3278: END;
3279: END finp_ins_roll_anc;
3280: FUNCTION finp_ins_roll_revseg(
3281: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
3282: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
3283: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3284: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
3285: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3286: p_message_name OUT NOCOPY VARCHAR2
3279: END finp_ins_roll_anc;
3280: FUNCTION finp_ins_roll_revseg(
3281: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
3282: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
3283: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3284: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
3285: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3286: p_message_name OUT NOCOPY VARCHAR2
3287: )
3280: FUNCTION finp_ins_roll_revseg(
3281: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
3282: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
3283: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3284: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
3285: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3286: p_message_name OUT NOCOPY VARCHAR2
3287: )
3288: RETURN BOOLEAN AS
3281: p_fee_type IN IGS_FI_F_TYPE_ACCTS_ALL.fee_type%TYPE,
3282: p_source_cal_type IN IGS_CA_INST.cal_type%TYPE,
3283: p_source_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3284: p_dest_cal_type IN IGS_CA_INST.cal_type%TYPE,
3285: p_dest_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
3286: p_message_name OUT NOCOPY VARCHAR2
3287: )
3288: RETURN BOOLEAN AS
3289: /*************************************************************
3358: END finp_ins_roll_revseg;
3359:
3360: FUNCTION finpl_ins_roll_over_ftci_accts (
3361: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
3362: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
3363: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3364: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
3365: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
3366: ) RETURN BOOLEAN AS
3359:
3360: FUNCTION finpl_ins_roll_over_ftci_accts (
3361: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
3362: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
3363: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3364: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
3365: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
3366: ) RETURN BOOLEAN AS
3367: /*************************************************************
3360: FUNCTION finpl_ins_roll_over_ftci_accts (
3361: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
3362: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
3363: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3364: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
3365: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
3366: ) RETURN BOOLEAN AS
3367: /*************************************************************
3368: Created By : shtatiko
3361: p_v_fee_type IN igs_fi_f_type_accts_all.fee_type%TYPE,
3362: p_v_source_cal_type IN igs_ca_inst.cal_type%TYPE,
3363: p_n_source_sequence_number IN igs_ca_inst.sequence_number%TYPE,
3364: p_v_dest_cal_type IN igs_ca_inst.cal_type%TYPE,
3365: p_n_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE
3366: ) RETURN BOOLEAN AS
3367: /*************************************************************
3368: Created By : shtatiko
3369: Date Created By : 14-MAY-2003
3541: END finpl_ins_roll_over_ftci_accts;
3542:
3543:
3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
3542:
3543:
3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
3550: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3543:
3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
3550: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3551: /*************************************************************
3544: FUNCTION finp_ins_roll_trg_grp( p_fee_cat IN igs_fi_fee_trg_grp.fee_cat%TYPE ,
3545: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3546: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3547: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3548: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3549: p_fee_type IN igs_fi_fee_trg_grp.fee_type%TYPE ,
3550: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3551: /*************************************************************
3552: Created By : Priya Athipatla
3654: END finp_ins_roll_trg_grp;
3655:
3656:
3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
3655:
3656:
3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
3663: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3656:
3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
3663: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3664: /*************************************************************
3657: FUNCTION finp_ins_roll_uft( p_fee_cat IN igs_fi_unit_fee_trg.fee_cat%TYPE ,
3658: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3659: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3660: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3661: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3662: p_fee_type IN igs_fi_unit_fee_trg.fee_type%TYPE ,
3663: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3664: /*************************************************************
3665: Created By : Priya Athipatla
3671: akandreg 02-Dec-2005 Bug 4747757. Added cursor cur_chk_version to handle the
3672: issue of rolling over a unit fee trigger when version is
3673: not specified at FCFL level.
3674: svuppala 11-March-2004 Bug 4224379 - New cursor 'c_alt_cd' is created to get "Alternate code" from
3675: igs_ca_inst_all and to send as a token in IGS_FI_ROLLOVER_UFT_ERROR.
3676: Added an EXCEPTION to log a message in case of rolling over failure.
3677: (reverse chronological order - newest change first)
3678: ***************************************************************/
3679: l_v_unit_cd igs_fi_unit_fee_trg.unit_cd%TYPE;
3682: l_b_record_inserted_ind BOOLEAN := FALSE;
3683: l_b_record_exists_ind BOOLEAN := FALSE;
3684: l_v_message_name fnd_new_messages.message_name%TYPE;
3685: l_rowid ROWID := NULL;
3686: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;
3687:
3688: -- Cursor to obtain data from Source Calendar Instance
3689: CURSOR c_uft_source IS
3690: SELECT uft.unit_cd,
3707:
3708: CURSOR c_alt_cd (cp_cal_type igs_fi_unit_fee_trg.cal_type%TYPE,
3709: cp_ci_sequence_number igs_fi_unit_fee_trg.ci_sequence_number%TYPE) IS
3710: SELECT cinst.alternate_code
3711: FROM igs_ca_inst_all cinst
3712: WHERE cinst.cal_type = cp_cal_type
3713: AND cinst.sequence_number = cp_ci_sequence_number;
3714:
3715: -- Cursor to check IF data already exists in Destination Calendar Instance
3834: END finp_ins_roll_uft;
3835:
3836:
3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
3835:
3836:
3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
3843: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3836:
3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
3843: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3844: /*************************************************************
3837: FUNCTION finp_ins_roll_usft( p_fee_cat IN igs_en_unitsetfeetrg.fee_cat%TYPE ,
3838: p_source_cal_type IN igs_ca_inst.cal_type%TYPE ,
3839: p_source_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3840: p_dest_cal_type IN igs_ca_inst.cal_type%TYPE ,
3841: p_dest_sequence_number IN igs_ca_inst.sequence_number%TYPE ,
3842: p_fee_type IN igs_en_unitsetfeetrg.fee_type%TYPE ,
3843: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE ) RETURN BOOLEAN AS
3844: /*************************************************************
3845: Created By : Priya Athipatla
3987: AND fee_type = cp_fee_type
3988: AND (teach_cal_type IS NOT NULL AND teach_ci_sequence_number IS NOT NULL);
3989:
3990: -- Cursor for identifying the Rolled Over Instance of Teaching Period
3991: CURSOR cur_roll_tp(cp_cal_type igs_ca_inst.cal_type%TYPE,
3992: cp_seq_number igs_ca_inst.sequence_number%TYPE) IS
3993: SELECT cal_type,
3994: sequence_number
3995: FROM igs_ca_inst
3988: AND (teach_cal_type IS NOT NULL AND teach_ci_sequence_number IS NOT NULL);
3989:
3990: -- Cursor for identifying the Rolled Over Instance of Teaching Period
3991: CURSOR cur_roll_tp(cp_cal_type igs_ca_inst.cal_type%TYPE,
3992: cp_seq_number igs_ca_inst.sequence_number%TYPE) IS
3993: SELECT cal_type,
3994: sequence_number
3995: FROM igs_ca_inst
3996: WHERE cal_type = cp_cal_type
3991: CURSOR cur_roll_tp(cp_cal_type igs_ca_inst.cal_type%TYPE,
3992: cp_seq_number igs_ca_inst.sequence_number%TYPE) IS
3993: SELECT cal_type,
3994: sequence_number
3995: FROM igs_ca_inst
3996: WHERE cal_type = cp_cal_type
3997: AND prior_ci_sequence_number = cp_seq_number;
3998:
3999: -- Cursor for identifying the Retention Schedules
3999: -- Cursor for identifying the Retention Schedules
4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
4003: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4004: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
4005: SELECT *
4006: FROM igs_fi_tp_ret_schd
4007: WHERE fee_cal_type = cp_fee_cal_type
4000: CURSOR cur_ret_schdl(cp_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE,
4001: cp_fee_ci_seq_num igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE,
4002: cp_fee_type igs_fi_f_typ_ca_inst.fee_type%TYPE,
4003: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4004: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
4005: SELECT *
4006: FROM igs_fi_tp_ret_schd
4007: WHERE fee_cal_type = cp_fee_cal_type
4008: AND fee_ci_sequence_number = cp_fee_ci_seq_num
4011: AND teach_ci_sequence_number = cp_teach_seq_num;
4012:
4013: -- Cursor for validating IF the Load calendar Instance has the Rolled Over
4014: -- Teaching period associated
4015: CURSOR cur_load_teach(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
4016: cp_load_seq_number igs_ca_inst.sequence_number%TYPE,
4017: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4018: cp_teach_seq_number igs_ca_inst.sequence_number%TYPE) IS
4019: SELECT 'x'
4012:
4013: -- Cursor for validating IF the Load calendar Instance has the Rolled Over
4014: -- Teaching period associated
4015: CURSOR cur_load_teach(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
4016: cp_load_seq_number igs_ca_inst.sequence_number%TYPE,
4017: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4018: cp_teach_seq_number igs_ca_inst.sequence_number%TYPE) IS
4019: SELECT 'x'
4020: FROM igs_ca_load_to_teach_v
4013: -- Cursor for validating IF the Load calendar Instance has the Rolled Over
4014: -- Teaching period associated
4015: CURSOR cur_load_teach(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
4016: cp_load_seq_number igs_ca_inst.sequence_number%TYPE,
4017: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4018: cp_teach_seq_number igs_ca_inst.sequence_number%TYPE) IS
4019: SELECT 'x'
4020: FROM igs_ca_load_to_teach_v
4021: WHERE load_cal_type = cp_load_cal_type
4014: -- Teaching period associated
4015: CURSOR cur_load_teach(cp_load_cal_type igs_ca_inst.cal_type%TYPE,
4016: cp_load_seq_number igs_ca_inst.sequence_number%TYPE,
4017: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
4018: cp_teach_seq_number igs_ca_inst.sequence_number%TYPE) IS
4019: SELECT 'x'
4020: FROM igs_ca_load_to_teach_v
4021: WHERE load_cal_type = cp_load_cal_type
4022: AND load_ci_sequence_number = cp_load_seq_number
4039:
4040: l_rec_roll_tp cur_roll_tp%ROWTYPE;
4041: l_var VARCHAR2(1);
4042:
4043: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
4044: l_n_load_seq_num igs_ca_inst.sequence_number%TYPE;
4045: l_b_ret_val BOOLEAN;
4046: l_v_message_name fnd_new_messages.message_name%TYPE;
4047: l_b_rec_found BOOLEAN;
4040: l_rec_roll_tp cur_roll_tp%ROWTYPE;
4041: l_var VARCHAR2(1);
4042:
4043: l_v_load_cal_type igs_ca_inst.cal_type%TYPE;
4044: l_n_load_seq_num igs_ca_inst.sequence_number%TYPE;
4045: l_b_ret_val BOOLEAN;
4046: l_v_message_name fnd_new_messages.message_name%TYPE;
4047: l_b_rec_found BOOLEAN;
4048: l_n_ret_id igs_fi_tp_ret_schd.ftci_teach_retention_id%TYPE;
4051: l_rec_dai cur_dai_exist%ROWTYPE;
4052:
4053: l_rec_ret_schdl cur_ret_schdl%ROWTYPE;
4054:
4055: l_v_fp_alt_cd igs_ca_inst.alternate_code%TYPE;
4056: l_v_dest_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4057: l_v_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4058: l_v_teach_label igs_lookup_values.meaning%TYPE;
4059:
4052:
4053: l_rec_ret_schdl cur_ret_schdl%ROWTYPE;
4054:
4055: l_v_fp_alt_cd igs_ca_inst.alternate_code%TYPE;
4056: l_v_dest_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4057: l_v_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4058: l_v_teach_label igs_lookup_values.meaning%TYPE;
4059:
4060: BEGIN
4053: l_rec_ret_schdl cur_ret_schdl%ROWTYPE;
4054:
4055: l_v_fp_alt_cd igs_ca_inst.alternate_code%TYPE;
4056: l_v_dest_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4057: l_v_teach_alt_cd igs_ca_inst.alternate_code%TYPE;
4058: l_v_teach_label igs_lookup_values.meaning%TYPE;
4059:
4060: BEGIN
4061: