eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_WHATIF_DEPRN2_PKG dependencies on FA_RX_SHARED_PKG

Line 51: h_cat_segs fa_rx_shared_pkg.Seg_Array;

47: h_count number;
48: ret boolean;
49: h_mesg_name varchar2(30);
50: h_mesg_str varchar2(2000);
51: h_cat_segs fa_rx_shared_pkg.Seg_Array;
52: h_concat_str varchar2(200);
53: h_currency varchar2(15);
54: h_basic_rate number;
55: x_errbuf varchar2(200);

Line 282: fa_rx_shared_pkg.g_seg_count := 0; /Bug#12327960 /

278:
279: -- Aggregate selects here:
280:
281: h_mesg_name := 'FA_REC_SQL_ACCT_FLEX';
282: fa_rx_shared_pkg.g_seg_count := 0; /*Bug#12327960 */
283: open c_segs;
284: loop
285:
286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,

Line 286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,

282: fa_rx_shared_pkg.g_seg_count := 0; /*Bug#12327960 */
283: open c_segs;
284: loop
285:
286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,
287: fa_rx_shared_pkg.g_seg_struct.table_id,
288: fa_rx_shared_pkg.g_seg_struct.colname,
289: fa_rx_shared_pkg.g_seg_struct.segment_num,
290: fa_rx_shared_pkg.g_seg_struct.delimiter;

Line 287: fa_rx_shared_pkg.g_seg_struct.table_id,

283: open c_segs;
284: loop
285:
286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,
287: fa_rx_shared_pkg.g_seg_struct.table_id,
288: fa_rx_shared_pkg.g_seg_struct.colname,
289: fa_rx_shared_pkg.g_seg_struct.segment_num,
290: fa_rx_shared_pkg.g_seg_struct.delimiter;
291:

Line 288: fa_rx_shared_pkg.g_seg_struct.colname,

284: loop
285:
286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,
287: fa_rx_shared_pkg.g_seg_struct.table_id,
288: fa_rx_shared_pkg.g_seg_struct.colname,
289: fa_rx_shared_pkg.g_seg_struct.segment_num,
290: fa_rx_shared_pkg.g_seg_struct.delimiter;
291:
292: if (c_segs%NOTFOUND) then

Line 289: fa_rx_shared_pkg.g_seg_struct.segment_num,

285:
286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,
287: fa_rx_shared_pkg.g_seg_struct.table_id,
288: fa_rx_shared_pkg.g_seg_struct.colname,
289: fa_rx_shared_pkg.g_seg_struct.segment_num,
290: fa_rx_shared_pkg.g_seg_struct.delimiter;
291:
292: if (c_segs%NOTFOUND) then
293: exit;

Line 290: fa_rx_shared_pkg.g_seg_struct.delimiter;

286: FETCH c_segs into fa_rx_shared_pkg.g_seg_struct.tabname,
287: fa_rx_shared_pkg.g_seg_struct.table_id,
288: fa_rx_shared_pkg.g_seg_struct.colname,
289: fa_rx_shared_pkg.g_seg_struct.segment_num,
290: fa_rx_shared_pkg.g_seg_struct.delimiter;
291:
292: if (c_segs%NOTFOUND) then
293: exit;
294: end if;

Line 297: if (fa_rx_shared_pkg.g_seg_count = 0) then /* initialize the table. */

293: exit;
294: end if;
295:
296: -- load the table.
297: if (fa_rx_shared_pkg.g_seg_count = 0) then /* initialize the table. */
298: fa_rx_shared_pkg.g_seg_table.delete;
299: end if;
300: fa_rx_shared_pkg.g_seg_count := fa_rx_shared_pkg.g_seg_count + 1;
301:

Line 298: fa_rx_shared_pkg.g_seg_table.delete;

294: end if;
295:
296: -- load the table.
297: if (fa_rx_shared_pkg.g_seg_count = 0) then /* initialize the table. */
298: fa_rx_shared_pkg.g_seg_table.delete;
299: end if;
300: fa_rx_shared_pkg.g_seg_count := fa_rx_shared_pkg.g_seg_count + 1;
301:
302: fa_rx_shared_pkg.g_seg_table(fa_rx_shared_pkg.g_seg_count) := fa_rx_shared_pkg.g_seg_struct;

Line 300: fa_rx_shared_pkg.g_seg_count := fa_rx_shared_pkg.g_seg_count + 1;

296: -- load the table.
297: if (fa_rx_shared_pkg.g_seg_count = 0) then /* initialize the table. */
298: fa_rx_shared_pkg.g_seg_table.delete;
299: end if;
300: fa_rx_shared_pkg.g_seg_count := fa_rx_shared_pkg.g_seg_count + 1;
301:
302: fa_rx_shared_pkg.g_seg_table(fa_rx_shared_pkg.g_seg_count) := fa_rx_shared_pkg.g_seg_struct;
303:
304:

Line 302: fa_rx_shared_pkg.g_seg_table(fa_rx_shared_pkg.g_seg_count) := fa_rx_shared_pkg.g_seg_struct;

298: fa_rx_shared_pkg.g_seg_table.delete;
299: end if;
300: fa_rx_shared_pkg.g_seg_count := fa_rx_shared_pkg.g_seg_count + 1;
301:
302: fa_rx_shared_pkg.g_seg_table(fa_rx_shared_pkg.g_seg_count) := fa_rx_shared_pkg.g_seg_struct;
303:
304:
305: end loop;
306: close c_segs;

Line 608: fa_rx_shared_pkg.concat_category(h_cat_struct,

604: into h_currency
605: from gl_sets_of_books
606: where set_of_books_id = FARX_C_WD.sob_id;
607:
608: fa_rx_shared_pkg.concat_category(h_cat_struct,
609: X_cat_id,
610: h_concat_str,
611: h_cat_segs);
612: