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 226: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', h_assetkey_flex_structure,'CAT','SELECT', 'BASED_CATEGORY');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 611: fa_rx_flex_pkg.get_description(

607: concat_string => h_concat_loc,
608: segarray => h_loc_segs);
609:
610: h_account_desc :=
611: fa_rx_flex_pkg.get_description(
612: p_application_id => 101,
613: p_id_flex_code => 'GL#',
614: p_id_flex_num => h_chart_of_accounts_id,
615: p_qualifier => 'GL_ACCOUNT',

Line 619: fa_rx_flex_pkg.get_description(

615: p_qualifier => 'GL_ACCOUNT',
616: p_data => h_cost_acct);
617:
618: h_cost_center_desc :=
619: fa_rx_flex_pkg.get_description(
620: p_application_id => 101,
621: p_id_flex_code => 'GL#',
622: p_id_flex_num => h_chart_of_accounts_id,
623: p_qualifier => 'FA_COST_CTR',

Line 635: fa_rx_flex_pkg.get_value(

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

Line 644: fa_rx_flex_pkg.get_description(

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

Line 658: fa_rx_flex_pkg.get_value(

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

Line 671: fa_rx_flex_pkg.get_description(

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

Line 684: fa_rx_flex_pkg.get_value(

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

Line 697: fa_rx_flex_pkg.get_description(

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