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 345: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',

341: -- BALANCING --
342: if param.from_bal is not null and param.to_bal is not null then
343:
344: l_param_where := l_param_where || ' AND (' ||
345: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
346: 'SELECT', 'GL_BALANCING')||' between :from_bal and :to_bal)';
347:
348: end if;
349:

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

351:
352: -- ACCOUNT --
353: if param.from_acct is not null and param.to_acct is not null then
354: l_param_where := l_param_where || ' AND (' ||
355: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
356: 'SELECT', 'GL_ACCOUNT') || ' between :from_acct and :to_acct)';
357:
358: end if;
359:

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

359:
360: -- COST CENTER --
361: if param.from_cc is not null and param.to_cc is not null then
362: l_param_where := l_param_where || ' AND (' ||
363: fa_rx_flex_pkg.flex_sql(101,'GL#', var.chart_of_accounts_id,'CC',
364: 'SELECT', 'FA_COST_CTR') ||' between :from_cc and :to_cc)';
365: end if;
366:
367: -- Major Category --

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

366:
367: -- Major Category --
368: if param.from_maj_cat is not null and param.to_maj_cat is not null then
369: l_param_where := l_param_where || ' AND (' ||
370: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
371: 'SELECT', 'BASED_CATEGORY') ||' between :from_maj_cat and :to_maj_cat)';
372:
373: end if;
374:

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

375: -- Minor Category --
376: begin
377: if param.from_min_cat is not null and param.to_min_cat is not null then
378: l_param_where := l_param_where || ' AND (' ||
379: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
380: 'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';
381:
382: elsif param.from_min_cat is not null and param.to_min_cat is null then
383: l_param_where := l_param_where || ' AND (' ||

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

380: 'SELECT', 'MINOR_CATEGORY') ||' between :from_min_cat and :to_min_cat)';
381:
382: elsif param.from_min_cat is not null and param.to_min_cat is null then
383: l_param_where := l_param_where || ' AND (' ||
384: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
385: 'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';
386: elsif param.from_min_cat is null and param.to_min_cat is not null then
387: l_param_where := l_param_where || ' AND (' ||
388: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',

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

384: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
385: 'SELECT', 'MINOR_CATEGORY') ||'>= :from_min_cat)';
386: elsif param.from_min_cat is null and param.to_min_cat is not null then
387: l_param_where := l_param_where || ' AND (' ||
388: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
389: 'SELECT', 'MINOR_CATEGORY') ||'<= :to_min_cat )';
390: end if;
391: exception
392: when others then

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

411: IF (param.cat_seg_num IS NOT NULL) THEN
412: var.cat_seg_num := param.cat_seg_num;
413: if param.from_cat_seg_val is not null and param.to_cat_seg_val is not null then
414: l_param_where := l_param_where || ' AND (' ||
415: fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT',
416: 'SELECT',param.cat_seg_num) ||' between from_cat_seg_val and :to_cat_seg_val)';
417:
418: end if;
419: END IF;

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

421: --
422: -- Get Columns for Major_category, Minor_category and Specified_category
423: --
424:
425: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');
426:
427: begin
428: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');
429: exception

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

424:
425: maj_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'BASED_CATEGORY');
426:
427: begin
428: min_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', 'MINOR_CATEGORY');
429: exception
430: when others then
431: min_select_statement := 'null';
432: var.minor_category := null;

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

433: end;
434:
435: begin
436: if param.cat_seg_num <> '' then
437: spec_select_statement := fa_rx_flex_pkg.flex_sql(140,'CAT#', var.cat_flex_struct,'CAT','SELECT', param.cat_seg_num);
438: else
439: spec_select_statement := 'null';
440: var.specified_cat_seg := null;
441: end if;

Line 718: fa_rx_flex_pkg.get_description(

714: END;
715: end if;
716:
717: var.company_description :=
718: fa_rx_flex_pkg.get_description(
719: p_application_id => 101,
720: p_id_flex_code => 'GL#',
721: p_id_flex_num => var.chart_of_accounts_id,
722: p_qualifier => 'GL_BALANCING',

Line 726: fa_rx_flex_pkg.get_description(

722: p_qualifier => 'GL_BALANCING',
723: p_data => var.acct_all_segs(var.bal_segnum));
724:
725: var.expense_acct_description :=
726: fa_rx_flex_pkg.get_description(
727: p_application_id => 101,
728: p_id_flex_code => 'GL#',
729: p_id_flex_num => var.chart_of_accounts_id,
730: p_qualifier => 'GL_ACCOUNT',

Line 734: fa_rx_flex_pkg.get_description(

730: p_qualifier => 'GL_ACCOUNT',
731: p_data => var.acct_all_segs(var.acct_segnum));
732:
733: var.reserve_acct_desc :=
734: fa_rx_flex_pkg.get_description(
735: p_application_id => 101,
736: p_id_flex_code => 'GL#',
737: p_id_flex_num => var.chart_of_accounts_id,
738: p_qualifier => 'GL_ACCOUNT',

Line 742: fa_rx_flex_pkg.get_description(

738: p_qualifier => 'GL_ACCOUNT',
739: p_data => var.deprn_rsv_acct);
740:
741: var.cost_center_description :=
742: fa_rx_flex_pkg.get_description(
743: p_application_id => 101,
744: p_id_flex_code => 'GL#',
745: p_id_flex_num => var.chart_of_accounts_id,
746: p_qualifier => 'FA_COST_CTR',

Line 751: fa_rx_flex_pkg.get_description(

747: p_data => var.acct_all_segs(var.cc_segnum));
748:
749: begin
750: var.major_category_desc :=
751: fa_rx_flex_pkg.get_description(
752: p_application_id => 140,
753: p_id_flex_code => 'CAT#',
754: p_id_flex_num => var.cat_flex_struct,
755: p_qualifier => 'BASED_CATEGORY',

Line 764: fa_rx_flex_pkg.get_description(

760: end;
761:
762: begin
763: var.minor_category_desc :=
764: fa_rx_flex_pkg.get_description(
765: p_application_id => 140,
766: p_id_flex_code => 'CAT#',
767: p_id_flex_num => var.cat_flex_struct,
768: p_qualifier => 'MINOR_CATEGORY',

Line 777: fa_rx_flex_pkg.get_description(

773: end;
774:
775: begin
776: var.specified_cat_seg_desc :=
777: fa_rx_flex_pkg.get_description(
778: p_application_id => 140,
779: p_id_flex_code => 'CAT#',
780: p_id_flex_num => var.cat_flex_struct,
781: p_qualifier => param.cat_seg_num,