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.28 2011/02/16 14:21:05 gigupta ship $ */
3:
4:
5: type flex_val_rec is record (

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

749: l_use_global_table varchar2(10);
750:
751: BEGIN
752:
753: if (fa_rx_shared_pkg.g_seg_count = 0) then
754: l_use_global_table := 'NO';
755: else
756: l_use_global_table := 'YES';
757: end if;

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

801: close segcolumns;
802:
803:
804: else
805: FOR i IN fa_rx_shared_pkg.g_seg_table.FIRST .. fa_rx_shared_pkg.g_seg_table.LAST LOOP
806:
807: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
808:
809:

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

803:
804: else
805: FOR i IN fa_rx_shared_pkg.g_seg_table.FIRST .. fa_rx_shared_pkg.g_seg_table.LAST LOOP
806:
807: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
808:
809:
810: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
811: num_segs := num_segs + 1;

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

806:
807: if table_name = fa_rx_shared_pkg.g_seg_table(i).tabname then
808:
809:
810: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
811: num_segs := num_segs + 1;
812: delim := fa_rx_shared_pkg.g_seg_table(i).delimiter;
813:
814: segarray(num_segs) := 'seeded';

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

808:
809:
810: v_sqlstmt := v_sqlstmt || fa_rx_shared_pkg.g_seg_table(i).colname || ', ';
811: num_segs := num_segs + 1;
812: delim := fa_rx_shared_pkg.g_seg_table(i).delimiter;
813:
814: segarray(num_segs) := 'seeded';
815:
816: end if;

Line 1761: h_loc_segs fa_rx_shared_pkg.Seg_Array;

1757: h_invoice_descr VARCHAR2(240);
1758: h_retirement_type VARCHAR2(80);
1759: h_location VARCHAR2(240);
1760: h_location_id NUMBER;
1761: h_loc_segs fa_rx_shared_pkg.Seg_Array;
1762: h_ccid NUMBER;
1763:
1764: first_vendor BOOLEAN := TRUE;
1765: first_invoice_number BOOLEAN := TRUE;

Line 1776: acct_all_segs fa_rx_shared_pkg.Seg_Array;

1772: concat_invoice_descr VARCHAR2(1000);
1773: concat_retirement_type VARCHAR2(1000);
1774: concat_location VARCHAR2(1000);
1775:
1776: acct_all_segs fa_rx_shared_pkg.Seg_Array;
1777: n_segs number;
1778: gl_balancing_seg number;
1779: gl_account_seg number;
1780: fa_cost_ctr_seg number;

Line 1909: fa_rx_shared_pkg.get_acct_segment_numbers (

1905: then
1906:
1907: /* Get accounting flexfield's segment numbers */
1908:
1909: fa_rx_shared_pkg.get_acct_segment_numbers (
1910: BOOK => v_book_type_code,
1911: BALANCING_SEGNUM => gl_balancing_seg,
1912: ACCOUNT_SEGNUM => gl_account_seg,
1913: CC_SEGNUM => fa_cost_ctr_seg,

Line 1924: fa_rx_shared_pkg.get_acct_segments (

1920: if (c_location%NOTFOUND) then exit; end if;
1921:
1922: /* Get accounting flexfield segment values */
1923:
1924: fa_rx_shared_pkg.get_acct_segments (
1925: combination_id => h_ccid,
1926: n_segments => n_segs,
1927: segments => acct_all_segs,
1928: calling_fn => 'FA_BALANCES_REPORT');

Line 1937: fa_rx_shared_pkg.concat_location (

1933: then
1934:
1935: /* Get concatenated location */
1936:
1937: fa_rx_shared_pkg.concat_location (
1938: struct_id => g_loc_flex_struct,
1939: ccid => h_location_id,
1940: concat_string => h_location,
1941: segarray => h_loc_segs);

Line 1974: END FA_RX_SHARED_PKG;

1970: BEGIN
1971: flex_val_count := 0;
1972: END clear_flex_val_cache;
1973:
1974: END FA_RX_SHARED_PKG;