[Home] [Help]
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: --
224: -- Routine to rollover IGS_PS_COURSE type fee triggers between cal instances
225: FUNCTION finp_ins_roll_ctft(
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
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: --
276: -- To rollover Ancillary related segments and the rate when the Fee Calendar Instance gets rolled over
277: FUNCTION finp_ins_roll_anc(
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
430: SELECT cat.cal_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
3553: Date Created By : 12-Jul-2004
3554: Purpose : To rollover Fee Trigger Groups
3562: l_n_fee_trigger_group_number igs_fi_fee_trg_grp.fee_trigger_group_number%TYPE;
3563: l_d_logical_delete_dt igs_fi_fee_trg_grp.logical_delete_dt%TYPE;
3564: l_b_record_inserted_ind BOOLEAN := FALSE;
3565: l_b_record_exists_ind BOOLEAN := FALSE;
3566: l_v_message_name fnd_new_messages.message_name%TYPE;
3567: l_rowid ROWID := NULL;
3568:
3569: -- Cursor to obtain data from Source Calendar Instance
3570: CURSOR c_trg_grp_source IS
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
3666: Date Created By : 12-Jul-2004
3667: Purpose : To rollover Unit Fee Triggers
3680: l_v_sequence_number igs_fi_unit_fee_trg.sequence_number%TYPE;
3681: l_d_logical_delete_dt igs_fi_unit_fee_trg.logical_delete_dt%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
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
3846: Date Created By : 12-Jul-2004
3847: Purpose : To rollover Unit Set Fee Triggers
3856: l_v_version_number igs_en_unitsetfeetrg.version_number%TYPE;
3857: l_d_logical_delete_dt igs_en_unitsetfeetrg.logical_delete_dt%TYPE;
3858: l_b_record_inserted_ind BOOLEAN := FALSE;
3859: l_b_record_exists_ind BOOLEAN := FALSE;
3860: l_v_message_name fnd_new_messages.message_name%TYPE;
3861: l_rowid ROWID := NULL;
3862: l_d_create_dt igs_en_unitsetfeetrg.create_dt%TYPE;
3863:
3864: -- Cursor to obtain data from Source Calendar Instance
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;
4049: l_v_rowid VARCHAR2(25);
4050: l_b_prc_rollover BOOLEAN;