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.FARX_AL dependencies on FA_RX_FLEX_PKG

Line 260: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

256: l_param_where := null;
257:
258: -- BALANCING --
259: l_param_where := l_param_where || ' AND (' ||
260: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
261: 'SELECT', 'GL_BALANCING') ||' >= :from_bal or :from_bal is NULL)';
262:
263: l_param_where := l_param_where || ' AND (' ||
264: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

Line 264: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

260: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
261: 'SELECT', 'GL_BALANCING') ||' >= :from_bal or :from_bal is NULL)';
262:
263: l_param_where := l_param_where || ' AND (' ||
264: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
265: 'SELECT', 'GL_BALANCING') ||' <= :to_bal or :to_bal is NULL)';
266:
267: -- ACCOUNT --
268: l_param_where := l_param_where || ' AND (' ||

Line 269: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

265: 'SELECT', 'GL_BALANCING') ||' <= :to_bal or :to_bal is NULL)';
266:
267: -- ACCOUNT --
268: l_param_where := l_param_where || ' AND (' ||
269: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
270: 'SELECT', 'GL_ACCOUNT') ||' >= :from_acct or :from_acct is NULL)';
271:
272: l_param_where := l_param_where || ' AND (' ||
273: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

Line 273: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

269: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
270: 'SELECT', 'GL_ACCOUNT') ||' >= :from_acct or :from_acct is NULL)';
271:
272: l_param_where := l_param_where || ' AND (' ||
273: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
274: 'SELECT', 'GL_ACCOUNT') ||' <= :to_acct or :to_acct is NULL)';
275:
276: -- COST CENTER --
277: l_param_where := l_param_where || ' AND (' ||

Line 278: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

274: 'SELECT', 'GL_ACCOUNT') ||' <= :to_acct or :to_acct is NULL)';
275:
276: -- COST CENTER --
277: l_param_where := l_param_where || ' AND (' ||
278: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
279: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
280:
281: l_param_where := l_param_where || ' AND (' ||
282: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

Line 282: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',

278: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
279: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
280:
281: l_param_where := l_param_where || ' AND (' ||
282: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'CC',
283: 'SELECT', 'FA_COST_CTR') ||' <= :to_cc or :to_cc is NULL)';
284:
285: -- Major Category --
286: l_param_where := l_param_where || ' AND (' ||

Line 287: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',

283: 'SELECT', 'FA_COST_CTR') ||' <= :to_cc or :to_cc is NULL)';
284:
285: -- Major Category --
286: l_param_where := l_param_where || ' AND (' ||
287: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',
288: 'SELECT', 'BASED_CATEGORY') ||'= :major_category or :major_category is NULL)';
289:
290: -- Minor Category --
291: begin

Line 293: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',

289:
290: -- Minor Category --
291: begin
292: l_param_where := l_param_where || ' AND (' ||
293: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',
294: 'SELECT', 'MINOR_CATEGORY') ||'= :minor_category or :minor_category is NULL)';
295: exception
296: when others then
297: l_param_where := l_param_where || ' AND (:minor_category is NULL and :minor_category is NULL)';

Line 330: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',

326:
327: -- Category Segment Number --
328: IF (cat_seg_num IS NOT NULL) THEN
329: l_param_where := l_param_where || ' AND ' ||
330: fa_rx_flex_pkg.flex_sql(140,'CAT#', cat_flex_struct,'CAT',
331: 'SELECT',cat_seg_num) || '= :cat_seg_val';
332: END IF;
333:
334: --

Line 340: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');

336: --
337: maj_select_column := null;
338: min_select_column := null;
339:
340: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');
341: maj_select_column := maj_select_column || ' MAJOR_CATEGORY';
342:
343: begin
344: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');

Line 344: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');

340: maj_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','BASED_CATEGORY');
341: maj_select_column := maj_select_column || ' MAJOR_CATEGORY';
342:
343: begin
344: min_select_column := fa_rx_flex_pkg.flex_sql(140,'CAT#',cat_flex_struct,'CAT','SELECT','MINOR_CATEGORY');
345: min_select_column := min_select_column || ' MINOR_CATEGORY';
346: exception
347: when others then
348: min_select_column := 'NULL';

Line 601: fa_rx_flex_pkg.get_description(

597: concat_key_str := ''; --bug#7456179
598: END IF;
599:
600: h_company_description :=
601: fa_rx_flex_pkg.get_description(
602: p_application_id => 101,
603: p_id_flex_code => 'GL#',
604: p_id_flex_num => h_chart_of_accounts_id,
605: p_qualifier => 'GL_BALANCING',

Line 609: fa_rx_flex_pkg.get_description(

605: p_qualifier => 'GL_BALANCING',
606: p_data => acct_all_segs(h_bal_segnum));
607:
608: h_expense_acct_description :=
609: fa_rx_flex_pkg.get_description(
610: p_application_id => 101,
611: p_id_flex_code => 'GL#',
612: p_id_flex_num => h_chart_of_accounts_id,
613: p_qualifier => 'GL_ACCOUNT',

Line 617: fa_rx_flex_pkg.get_description(

613: p_qualifier => 'GL_ACCOUNT',
614: p_data => acct_all_segs(h_acct_segnum));
615:
616: h_cost_center_description :=
617: fa_rx_flex_pkg.get_description(
618: p_application_id => 101,
619: p_id_flex_code => 'GL#',
620: p_id_flex_num => h_chart_of_accounts_id,
621: p_qualifier => 'FA_COST_CTR',