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

Line 374: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',

370: -- BALANCING --
371: if param.from_bal is not null and param.to_bal is not null then
372:
373: l_param_where := l_param_where || ' AND (' ||
374: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
375: 'SELECT', 'GL_BALANCING')||' between :from_bal and :to_bal)';
376:
377: end if;
378:

Line 384: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',

380:
381: -- ACCOUNT --
382: if param.from_acct is not null and param.to_acct is not null then
383: l_param_where := l_param_where || ' AND (' ||
384: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
385: 'SELECT', 'GL_ACCOUNT') || ' between :from_acct and :to_acct)';
386:
387: end if;
388:

Line 392: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',

388:
389: -- COST CENTER --
390: if param.from_cc is not null and param.to_cc is not null then
391: l_param_where := l_param_where || ' AND (' ||
392: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
393: 'SELECT', 'FA_COST_CTR') ||' between :from_cc and :to_cc)';
394: end if;
395:
396: -- Major Category --

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

395:
396: -- Major Category --
397: if param.from_maj_cat is not null and param.to_maj_cat is not null then
398: l_param_where := l_param_where || ' AND (' ||
399: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
400: 'SELECT', 'BASED_CATEGORY') ||' between :from_maj_cat and :to_maj_cat)';
401:
402: end if;
403:

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

404: -- Minor Category --
405: begin
406: if param.from_min_cat is not null and param.to_min_cat is not null then
407: l_param_where := l_param_where || ' AND (' ||
408: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
409: 'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';
410:
411: elsif param.from_min_cat is not null and param.to_min_cat is null then
412: l_param_where := l_param_where || ' AND (' ||

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

409: 'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';
410:
411: elsif param.from_min_cat is not null and param.to_min_cat is null then
412: l_param_where := l_param_where || ' AND (' ||
413: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
414: 'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';
415: elsif param.from_min_cat is null and param.to_min_cat is not null then
416: l_param_where := l_param_where || ' AND (' ||
417: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',

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

413: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
414: 'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';
415: elsif param.from_min_cat is null and param.to_min_cat is not null then
416: l_param_where := l_param_where || ' AND (' ||
417: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
418: 'SELECT', 'MINOR_CATEGORY') ||'<= :to_min_cat )';
419: end if;
420: exception
421: when others then

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

440: IF (param.cat_seg_num IS NOT NULL) THEN
441: var.cat_seg_num := param.cat_seg_num;
442: if param.from_cat_seg_val is not null and param.to_cat_seg_val is not null then
443: l_param_where := l_param_where || ' AND (' ||
444: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
445: 'SELECT',param.cat_seg_num) ||' between from_cat_seg_val and :to_cat_seg_val)';
446:
447: end if;
448: END IF;

Line 454: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');

450: --
451: -- Get Columns for Major_category, Minor_category and Specified_category
452: --
453:
454: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');
455:
456: begin
457: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');
458: exception

Line 457: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');

453:
454: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');
455:
456: begin
457: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');
458: exception
459: when others then
460: min_select_statement := 'null';
461: var.minor_category := null;

Line 466: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', param.cat_seg_num);

462: end;
463:
464: begin
465: if param.cat_seg_num <> '' then
466: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', param.cat_seg_num);
467: else
468: spec_select_statement := 'null';
469: var.specified_cat_seg := null;
470: end if;

Line 841: fa_rx_flex_pkg.get_description(

837: var.concat_key_str := ''; --bug#7456179
838: end if;
839:
840: var.company_description :=
841: fa_rx_flex_pkg.get_description(
842: p_application_id => 101,
843: p_id_flex_code => 'GL#',
844: p_id_flex_num => var.chart_of_accounts_id,
845: p_qualifier => 'GL_BALANCING',

Line 849: fa_rx_flex_pkg.get_description(

845: p_qualifier => 'GL_BALANCING',
846: p_data => var.acct_all_segs(var.bal_segnum));
847:
848: var.expense_acct_description :=
849: fa_rx_flex_pkg.get_description(
850: p_application_id => 101,
851: p_id_flex_code => 'GL#',
852: p_id_flex_num => var.chart_of_accounts_id,
853: p_qualifier => 'GL_ACCOUNT',

Line 857: fa_rx_flex_pkg.get_description(

853: p_qualifier => 'GL_ACCOUNT',
854: p_data => var.acct_all_segs(var.acct_segnum));
855:
856: var.reserve_acct_desc :=
857: fa_rx_flex_pkg.get_description(
858: p_application_id => 101,
859: p_id_flex_code => 'GL#',
860: p_id_flex_num => var.chart_of_accounts_id,
861: p_qualifier => 'GL_ACCOUNT',

Line 865: fa_rx_flex_pkg.get_description(

861: p_qualifier => 'GL_ACCOUNT',
862: p_data => var.deprn_rsv_acct);
863:
864: var.cost_center_description :=
865: fa_rx_flex_pkg.get_description(
866: p_application_id => 101,
867: p_id_flex_code => 'GL#',
868: p_id_flex_num => var.chart_of_accounts_id,
869: p_qualifier => 'FA_COST_CTR',

Line 874: fa_rx_flex_pkg.get_description(

870: p_data => var.acct_all_segs(var.cc_segnum));
871:
872: begin
873: var.major_category_desc :=
874: fa_rx_flex_pkg.get_description(
875: p_application_id => 140,
876: p_id_flex_code => 'CAT#',
877: p_id_flex_num => var.cat_flex_struct,
878: p_qualifier => 'BASED_CATEGORY',

Line 887: fa_rx_flex_pkg.get_description(

883: end;
884:
885: begin
886: var.minor_category_desc :=
887: fa_rx_flex_pkg.get_description(
888: p_application_id => 140,
889: p_id_flex_code => 'CAT#',
890: p_id_flex_num => var.cat_flex_struct,
891: p_qualifier => 'MINOR_CATEGORY',

Line 900: fa_rx_flex_pkg.get_description(

896: end;
897:
898: begin
899: var.specified_cat_seg_desc :=
900: fa_rx_flex_pkg.get_description(
901: p_application_id => 140,
902: p_id_flex_code => 'CAT#',
903: p_id_flex_num => var.cat_flex_struct,
904: p_qualifier => param.cat_seg_num,