[Home] [Help]
5: g_oracle_rec_installed igs_fi_control.rec_installed%TYPE;
6: g_n_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7:
8: TYPE accsegs IS RECORD(
9: l_segment igs_fi_acct_segs_v.segment%TYPE,
10: lv_Segment_num igs_fi_acct_segs_v.segment_num%TYPE,
11: lv_segment_value igs_ps_accts.segment_value%TYPE,
12: l_value_length fnd_flex_Value_Sets.maximum_size%TYPE);
13:
6: g_n_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
7:
8: TYPE accsegs IS RECORD(
9: l_segment igs_fi_acct_segs_v.segment%TYPE,
10: lv_Segment_num igs_fi_acct_segs_v.segment_num%TYPE,
11: lv_segment_value igs_ps_accts.segment_value%TYPE,
12: l_value_length fnd_flex_Value_Sets.maximum_size%TYPE);
13:
14: TYPE accsegs_list IS TABLE OF accsegs;
612: 5) If Build Account Process Runs successfully then it returns
613: TRUE to x_ret_status.
614: 6) In this procedure, for getting Revenue CCID for a charge transaction
615: traversing through entities is done. To Identify the Entity,
616: Lookups table(IGS_FI_ACCT_ENTITIES Lookup Type) data is used.
617:
618: Change History: (who, when, what: NO CREATION RECORDS HERE!)
619: Who When What
620: bannamal 03-JUN-2005 Bug#3442712 Unit Level Fee Assessment Build
719:
720: CURSOR cur_acc_segs
721: IS
722: SELECT seg.segment,seg.segment_num,val.maximum_size maximum_size
723: FROM igs_fi_acct_segs_v seg,
724: fnd_flex_value_sets val
725: WHERE seg.flex_value_set_id = val.flex_value_set_id
726: ORDER BY segment_num;
727:
761: l_entity_no NUMBER;
762: l_b_err_type1 BOOLEAN := FALSE;
763:
764: l_v_nat_acct_seg igs_fi_ftci_accts.natural_account_segment%TYPE;
765: l_v_account_cd igs_fi_acc.account_cd%TYPE;
766: l_n_err_type NUMBER;
767: l_v_err_msg fnd_new_messages.message_name%TYPE;
768: l_b_nat_rec BOOLEAN;
769: