DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_RX_SHARED_PKG

Line 1: PACKAGE BODY FA_RX_SHARED_PKG as

1: PACKAGE BODY FA_RX_SHARED_PKG as
2: /* $Header: farxb.pls 120.21 2006/02/02 06:25:46 tdewanga ship $ */
3:
4:
5: type flex_val_rec is record (

Line 604: if (fa_rx_shared_pkg.g_seg_count = 0) then

600: l_use_global_table varchar2(10);
601:
602: BEGIN
603:
604: if (fa_rx_shared_pkg.g_seg_count = 0) then
605: l_use_global_table := 'NO';
606: else
607: l_use_global_table := 'YES';
608: end if;

Line 656: FOR i IN fa_rx_shared_pkg.g_seg_table.FIRST .. fa_rx_shared_pkg.g_seg_table.LAST LOOP

652: close segcolumns;
653:
654:
655: else
656: FOR i IN fa_rx_shared_pkg.g_seg_table.FIRST .. fa_rx_shared_pkg.g_seg_table.LAST LOOP
657:
658: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
659:
660:

Line 658: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then

654:
655: else
656: FOR i IN fa_rx_shared_pkg.g_seg_table.FIRST .. fa_rx_shared_pkg.g_seg_table.LAST LOOP
657:
658: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
659:
660:
661: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
662: num_segs := num_segs + 1;

Line 661: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';

657:
658: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
659:
660:
661: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
662: num_segs := num_segs + 1;
663: delim := fa_rx_shared_pkg.g_seg_table(i).delimiter;
664:
665: segarray(num_segs) := 'seeded';

Line 663: delim := fa_rx_shared_pkg.g_seg_table(i).delimiter;

659:
660:
661: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
662: num_segs := num_segs + 1;
663: delim := fa_rx_shared_pkg.g_seg_table(i).delimiter;
664:
665: segarray(num_segs) := 'seeded';
666:
667: end if;

Line 1609: h_loc_segs fa_rx_shared_pkg.Seg_Array;

1605: h_invoice_descr VARCHAR2(240);
1606: h_retirement_type VARCHAR2(80);
1607: h_location VARCHAR2(240);
1608: h_location_id NUMBER;
1609: h_loc_segs fa_rx_shared_pkg.Seg_Array;
1610: h_ccid NUMBER;
1611:
1612: first_vendor BOOLEAN := TRUE;
1613: first_invoice_number BOOLEAN := TRUE;

Line 1624: acct_all_segs fa_rx_shared_pkg.Seg_Array;

1620: concat_invoice_descr VARCHAR2(1000);
1621: concat_retirement_type VARCHAR2(1000);
1622: concat_location VARCHAR2(1000);
1623:
1624: acct_all_segs fa_rx_shared_pkg.Seg_Array;
1625: n_segs number;
1626: gl_balancing_seg number;
1627: gl_account_seg number;
1628: fa_cost_ctr_seg number;

Line 1757: fa_rx_shared_pkg.get_acct_segment_numbers (

1753: then
1754:
1755: /* Get accounting flexfield's segment numbers */
1756:
1757: fa_rx_shared_pkg.get_acct_segment_numbers (
1758: BOOK => v_book_type_code,
1759: BALANCING_SEGNUM => gl_balancing_seg,
1760: ACCOUNT_SEGNUM => gl_account_seg,
1761: CC_SEGNUM => fa_cost_ctr_seg,

Line 1772: fa_rx_shared_pkg.get_acct_segments (

1768: if (c_location%NOTFOUND) then exit; end if;
1769:
1770: /* Get accounting flexfield segment values */
1771:
1772: fa_rx_shared_pkg.get_acct_segments (
1773: combination_id => h_ccid,
1774: n_segments => n_segs,
1775: segments => acct_all_segs,
1776: calling_fn => 'FA_BALANCES_REPORT');

Line 1785: fa_rx_shared_pkg.concat_location (

1781: then
1782:
1783: /* Get concatenated location */
1784:
1785: fa_rx_shared_pkg.concat_location (
1786: struct_id => g_loc_flex_struct,
1787: ccid => h_location_id,
1788: concat_string => h_location,
1789: segarray => h_loc_segs);

Line 1822: END FA_RX_SHARED_PKG;

1818: BEGIN
1819: flex_val_count := 0;
1820: END clear_flex_val_cache;
1821:
1822: END FA_RX_SHARED_PKG;