[Home] [Help]
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
806: -- previously established via the rollover, and it is now possible to do so.
807: --------------------------------------------------------------------------
808: p_message_name := Null;
809:
866: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String ('IGS','IGS_FI_FEETYPE_CALINST_ROLL'));
867:
868: v_ftci_exists_ind := TRUE;
869: v_insert_record := FALSE;
870: -- when the FTCI was rolled over, it's IGS_FI_ACC
871: -- may not have been able to be carried through.
872: -- The rollover process will again attempt to
873: -- establish the IGS_FI_ACC link.
874: v_process_next_ftci := TRUE;
869: v_insert_record := FALSE;
870: -- when the FTCI was rolled over, it's IGS_FI_ACC
871: -- may not have been able to be carried through.
872: -- The rollover process will again attempt to
873: -- establish the IGS_FI_ACC link.
874: v_process_next_ftci := TRUE;
875: ELSE
876: CLOSE c_ftci;
877: v_insert_record := TRUE;
3395: l_rec_ftci_accts cur_ftci_accts%ROWTYPE;
3396:
3397: CURSOR cur_rev_account_cd(cp_v_rev_acct_cd igs_fi_f_typ_ca_inst.rev_account_cd%TYPE) IS
3398: SELECT closed_ind
3399: FROM igs_fi_acc
3400: WHERE account_cd = cp_v_rev_acct_cd;
3401: l_rec_rev_account_cd cur_rev_account_cd%ROWTYPE;
3402:
3403: TYPE inactive_acc_tab_type IS TABLE OF igs_fi_ftci_accts.order_sequence%TYPE INDEX BY BINARY_INTEGER;
3446: key_flex_code => 'GL#',
3447: structure_number => igs_fi_gen_007.get_coa_id,
3448: displayable => g_n_segment_num,
3449: allow_nulls => TRUE,
3450: vrule => 'GL_ACCOUNT\nGL_ACCOUNT_TYPE\nI\nAPPL=IGS;NAME=IGS_FI_ACC_REV\nR',
3451: concat_segments => l_v_natural_account_segment
3452: );
3453: END IF;
3454: -- If there is an invalid segment then insert NULL for Natural Account Segment