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_RT dependencies on FA_RX_FLEX_PKG

Line 223: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');

219:
220: --
221: -- Get Columns for Major_category, Minor_category and Specified_category
222: --
223: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');
224:
225: begin
226: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');
227: exception

Line 226: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');

222: --
223: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');
224:
225: begin
226: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'MINOR_CATEGORY');
227: exception
228: when others then
229: min_select_statement := 'null';
230: end;

Line 233: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', cat_seg_num);

229: min_select_statement := 'null';
230: end;
231:
232: begin
233: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', cat_seg_num);
234: exception
235: when others then
236: spec_select_statement := 'null';
237: end;

Line 267: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

263: l_param_where := null;
264:
265: -- Major Category --
266: l_param_where := l_param_where || ' AND (' ||
267: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
268: 'SELECT', 'BASED_CATEGORY') ||' >= :from_maj_cat or :from_maj_cat is NULL)';
269:
270: l_param_where := l_param_where || ' AND (' ||
271: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 271: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

267: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
268: 'SELECT', 'BASED_CATEGORY') ||' >= :from_maj_cat or :from_maj_cat is NULL)';
269:
270: l_param_where := l_param_where || ' AND (' ||
271: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
272: 'SELECT', 'BASED_CATEGORY') ||' <= :to_maj_cat or :to_maj_cat is NULL)';
273:
274: -- Minor Category --
275: /*

Line 277: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

273:
274: -- Minor Category --
275: /*
276: l_param_where := l_param_where || ' AND (' ||
277: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
278: 'SELECT', 'MINOR_CATEGORY') ||' >= :from_min_cat or :from_min_cat is NULL)';
279:
280: l_param_where := l_param_where || ' AND (' ||
281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

277: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
278: 'SELECT', 'MINOR_CATEGORY') ||' >= :from_min_cat or :from_min_cat is NULL)';
279:
280: l_param_where := l_param_where || ' AND (' ||
281: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
282: 'SELECT', 'MINOR_CATEGORY') ||' <= :to_min_cat or :to_min_cat is NULL)';
283: */
284:
285: /* Fix for Bug# 2973255: Added expection handling to proceed

Line 290: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

286: in case that flex_sql fails when from_min_cat or to_min_cat are null
287: */
288: begin
289: l_param_where := l_param_where || ' AND (' ||
290: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
291: 'SELECT', 'MINOR_CATEGORY') ||' >= :from_min_cat or :from_min_cat is NULL)';
292: exception
293: when others then
294: l_param_where := l_param_where || ' AND (:from_min_cat is NULL and :from_min_cat is NULL)';

Line 299: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

295: end;
296:
297: begin
298: l_param_where := l_param_where || ' AND (' ||
299: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
300: 'SELECT', 'MINOR_CATEGORY') ||' <= :to_min_cat or :to_min_cat is NULL)';
301: exception
302: when others then
303: l_param_where := l_param_where || ' AND (:to_min_cat is NULL and :to_min_cat is NULL)';

Line 312: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

308: -- Category Segment Number --
309: IF (cat_seg_num IS NOT NULL) THEN
310: h_cat_seg_num := cat_seg_num;
311: l_param_where := l_param_where || ' AND (' ||
312: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
313: 'SELECT', cat_seg_num) ||' >= :from_cat_seg_val or :from_cat_seg_val is NULL)';
314:
315: l_param_where := l_param_where || ' AND (' ||
316: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

Line 316: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',

312: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
313: 'SELECT', cat_seg_num) ||' >= :from_cat_seg_val or :from_cat_seg_val is NULL)';
314:
315: l_param_where := l_param_where || ' AND (' ||
316: fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT',
317: 'SELECT', cat_seg_num) ||' <= :to_cat_seg_val or :to_cat_seg_val is NULL)';
318: ELSE
319: l_param_where := l_param_where || ' AND ( nvl(:from_cat_seg_val,-999) = -999 or :from_cat_seg_val is null)';
320: l_param_where := l_param_where || ' AND ( nvl(:to_cat_seg_val,-999) = -999 or :to_cat_seg_val is null)';

Line 334: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

330: END IF;
331: */
332:
333: l_param_where := l_param_where || ' AND (' ||
334: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
335: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
336:
337: l_param_where := l_param_where || ' AND (' ||
338: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

Line 338: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',

334: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
335: 'SELECT', 'FA_COST_CTR') ||' >= :from_cc or :from_cc is NULL)';
336:
337: l_param_where := l_param_where || ' AND (' ||
338: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_accounts_id,'DHCC',
339: 'SELECT', 'FA_COST_CTR') ||' <= :to_cc or :to_cc is NULL)';
340:
341:
342: /* BUG# 2939771

Line 609: fa_rx_flex_pkg.get_description(

605: concat_string => h_concat_loc,
606: segarray => h_loc_segs);
607:
608: h_account_desc :=
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 => h_cost_acct);
615:
616: h_cost_center_desc :=
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',

Line 633: fa_rx_flex_pkg.get_value(

629: END IF;
630:
631: /*
632: h_maj_cat :=
633: fa_rx_flex_pkg.get_value(
634: p_application_id => 140,
635: p_id_flex_code => 'CAT#',
636: p_id_flex_num => h_assetkey_flex_structure,
637: p_qualifier => 'BASED_CATEGORY',

Line 642: fa_rx_flex_pkg.get_description(

638: p_ccid => h_category_id);
639: */
640: begin
641: h_maj_cat_desc :=
642: fa_rx_flex_pkg.get_description(
643: p_application_id => 140,
644: p_id_flex_code => 'CAT#',
645: p_id_flex_num => h_assetkey_flex_structure,
646: p_qualifier => 'BASED_CATEGORY',

Line 656: fa_rx_flex_pkg.get_value(

652:
653: /*
654: BEGIN
655: h_min_cat :=
656: fa_rx_flex_pkg.get_value(
657: p_application_id => 140,
658: p_id_flex_code => 'CAT#',
659: p_id_flex_num => h_assetkey_flex_structure,
660: p_qualifier => 'MINOR_CATEGORY',

Line 669: fa_rx_flex_pkg.get_description(

665: end;
666: */
667: begin
668: h_min_cat_desc :=
669: fa_rx_flex_pkg.get_description(
670: p_application_id => 140,
671: p_id_flex_code => 'CAT#',
672: p_id_flex_num => h_assetkey_flex_structure,
673: p_qualifier => 'MINOR_CATEGORY',

Line 682: fa_rx_flex_pkg.get_value(

678: end;
679: /*
680: BEGIN
681: h_specified_cat :=
682: fa_rx_flex_pkg.get_value(
683: p_application_id => 140,
684: p_id_flex_code => 'CAT#',
685: p_id_flex_num => h_assetkey_flex_structure,
686: p_qualifier => h_cat_seg_num,

Line 695: fa_rx_flex_pkg.get_description(

691: end;
692: */
693: begin
694: h_specified_cat_desc :=
695: fa_rx_flex_pkg.get_description(
696: p_application_id => 140,
697: p_id_flex_code => 'CAT#',
698: p_id_flex_num => h_assetkey_flex_structure,
699: p_qualifier => h_cat_seg_num,