[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 ,
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