APPS.JG_RX_IR_PKG dependencies on FA_RX_FLEX_PKG

Line 420: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_acct_id,

416: if p_liability_min is null or p_liability_max is null then
417: l_liability_range_where := to_char(null);
418: else
419: l_liability_range_where :=' and '||
420: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_acct_id,
421: 'GC2','WHERE', 'ALL', 'BETWEEN',p_liability_min,p_liability_max)||' ';
422: end if;
423:
424: fa_rx_util_pkg.debug('l_liability_range_where :'||l_liability_range_where);

Line 432: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_acct_id,

428: if p_dist_acct_min is null or p_dist_acct_max is null then
429: l_dist_acct_range_where :=to_char(null);
430: else
431: l_dist_acct_range_where :=' and '||
432: fa_rx_flex_pkg.flex_sql(101,'GL#', h_chart_of_acct_id,
433: 'GC1','WHERE', 'ALL', 'BETWEEN',p_dist_acct_min, p_dist_acct_max) ||' ';
434: end if;
435:
436: fa_rx_util_pkg.debug('l_dist_acct_range_where :'||l_dist_acct_range_where);

Line 778: h_liability_acct := fa_rx_flex_pkg.get_value(

774: /* Get Liability account and description, natural account and description */
775:
776: if h_liability_ccid is not null then
777:
778: h_liability_acct := fa_rx_flex_pkg.get_value(
779: p_application_id => 101,
780: p_id_flex_code => 'GL#',
781: p_id_flex_num => h_chart_of_acct_id,
782: p_qualifier => 'ALL',

Line 785: h_liability_desc := fa_rx_flex_pkg.get_description(

781: p_id_flex_num => h_chart_of_acct_id,
782: p_qualifier => 'ALL',
783: p_ccid => h_liability_ccid);
784:
785: h_liability_desc := fa_rx_flex_pkg.get_description(
786: p_application_id => 101,
787: p_id_flex_code => 'GL#',
788: p_id_flex_num => h_chart_of_acct_id,
789: p_qualifier => 'ALL',

Line 792: h_liability_natacct := fa_rx_flex_pkg.get_value(

788: p_id_flex_num => h_chart_of_acct_id,
789: p_qualifier => 'ALL',
790: p_data => h_liability_acct);
791:
792: h_liability_natacct := fa_rx_flex_pkg.get_value(
793: p_application_id => 101,
794: p_id_flex_code => 'GL#',
795: p_id_flex_num => h_chart_of_acct_id,
796: p_qualifier => 'GL_ACCOUNT',

Line 799: h_liability_natdesc := fa_rx_flex_pkg.get_description(

795: p_id_flex_num => h_chart_of_acct_id,
796: p_qualifier => 'GL_ACCOUNT',
797: p_ccid => h_liability_ccid);
798:
799: h_liability_natdesc := fa_rx_flex_pkg.get_description(
800: p_application_id => 101,
801: p_id_flex_code => 'GL#',
802: p_id_flex_num => h_chart_of_acct_id,
803: p_qualifier => 'GL_ACCOUNT',

Line 822: h_dist_acct := fa_rx_flex_pkg.get_value(

818: /*Get Distribution account and description, natural account and description */
819:
820: if h_dist_ccid is not null then
821:
822: h_dist_acct := fa_rx_flex_pkg.get_value(
823: p_application_id => 101,
824: p_id_flex_code => 'GL#',
825: p_id_flex_num => h_chart_of_acct_id,
826: p_qualifier => 'ALL',

Line 829: h_dist_desc := fa_rx_flex_pkg.get_description(

825: p_id_flex_num => h_chart_of_acct_id,
826: p_qualifier => 'ALL',
827: p_ccid => h_dist_ccid);
828:
829: h_dist_desc := fa_rx_flex_pkg.get_description(
830: p_application_id => 101,
831: p_id_flex_code => 'GL#',
832: p_id_flex_num => h_chart_of_acct_id,
833: p_qualifier => 'ALL',

Line 836: h_dist_natacct := fa_rx_flex_pkg.get_value(

832: p_id_flex_num => h_chart_of_acct_id,
833: p_qualifier => 'ALL',
834: p_data => h_dist_acct);
835:
836: h_dist_natacct := fa_rx_flex_pkg.get_value(
837: p_application_id => 101,
838: p_id_flex_code => 'GL#',
839: p_id_flex_num => h_chart_of_acct_id,
840: p_qualifier => 'GL_ACCOUNT',

Line 843: h_dist_natdesc := fa_rx_flex_pkg.get_description(

839: p_id_flex_num => h_chart_of_acct_id,
840: p_qualifier => 'GL_ACCOUNT',
841: p_ccid => h_dist_ccid);
842:
843: h_dist_natdesc := fa_rx_flex_pkg.get_description(
844: p_application_id => 101,
845: p_id_flex_code => 'GL#',
846: p_id_flex_num => h_chart_of_acct_id,
847: p_qualifier => 'GL_ACCOUNT',