APPS.JG_RX_IR_PKG dependencies on FA_RX_FLEX_PKG

Line 391: fa_rx_flex_pkg.flex_sql(101,'GL#', p_chart_of_acct_id,

387: if p_liability_min is null or p_liability_max is null then
388: l_liability_range_where := to_char(null);
389: else
390: l_liability_range_where :=' and '||
391: fa_rx_flex_pkg.flex_sql(101,'GL#', p_chart_of_acct_id,
392: 'GC2','SELECT', 'ALL') || ' BETWEEN :c_liability_min and :c_liability_max ';
393: -- ,'BETWEEN',p_liability_min,p_liability_max);
394: end if;
395:

Line 404: fa_rx_flex_pkg.flex_sql(101,'GL#', p_chart_of_acct_id,

400: if p_dist_acct_min is null or p_dist_acct_max is null then
401: l_dist_acct_range_where :=to_char(null);
402: else
403: l_dist_acct_range_where :=' and '||
404: fa_rx_flex_pkg.flex_sql(101,'GL#', p_chart_of_acct_id,
405: 'GC1','SELECT', 'ALL') ||' BETWEEN :c_dist_acct_min and :c_dist_acct_max ';
406: end if;
407:
408: fa_rx_util_pkg.debug('l_dist_acct_range_where :'||l_dist_acct_range_where);

Line 749: h_liability_acct := fa_rx_flex_pkg.get_value(

745: /* Get Liability account and description, natural account and description */
746:
747: if h_liability_ccid is not null then
748:
749: h_liability_acct := fa_rx_flex_pkg.get_value(
750: p_application_id => 101,
751: p_id_flex_code => 'GL#',
752: p_id_flex_num => p_chart_of_acct_id,
753: p_qualifier => 'ALL',

Line 756: h_liability_desc := fa_rx_flex_pkg.get_description(

752: p_id_flex_num => p_chart_of_acct_id,
753: p_qualifier => 'ALL',
754: p_ccid => h_liability_ccid);
755:
756: h_liability_desc := fa_rx_flex_pkg.get_description(
757: p_application_id => 101,
758: p_id_flex_code => 'GL#',
759: p_id_flex_num => p_chart_of_acct_id,
760: p_qualifier => 'ALL',

Line 763: h_liability_natacct := fa_rx_flex_pkg.get_value(

759: p_id_flex_num => p_chart_of_acct_id,
760: p_qualifier => 'ALL',
761: p_data => h_liability_acct);
762:
763: h_liability_natacct := fa_rx_flex_pkg.get_value(
764: p_application_id => 101,
765: p_id_flex_code => 'GL#',
766: p_id_flex_num => p_chart_of_acct_id,
767: p_qualifier => 'GL_ACCOUNT',

Line 770: h_liability_natdesc := fa_rx_flex_pkg.get_description(

766: p_id_flex_num => p_chart_of_acct_id,
767: p_qualifier => 'GL_ACCOUNT',
768: p_ccid => h_liability_ccid);
769:
770: h_liability_natdesc := fa_rx_flex_pkg.get_description(
771: p_application_id => 101,
772: p_id_flex_code => 'GL#',
773: p_id_flex_num => p_chart_of_acct_id,
774: p_qualifier => 'GL_ACCOUNT',

Line 793: h_dist_acct := fa_rx_flex_pkg.get_value(

789: /*Get Distribution account and description, natural account and description */
790:
791: if h_dist_ccid is not null then
792:
793: h_dist_acct := fa_rx_flex_pkg.get_value(
794: p_application_id => 101,
795: p_id_flex_code => 'GL#',
796: p_id_flex_num => p_chart_of_acct_id,
797: p_qualifier => 'ALL',

Line 800: h_dist_desc := fa_rx_flex_pkg.get_description(

796: p_id_flex_num => p_chart_of_acct_id,
797: p_qualifier => 'ALL',
798: p_ccid => h_dist_ccid);
799:
800: h_dist_desc := fa_rx_flex_pkg.get_description(
801: p_application_id => 101,
802: p_id_flex_code => 'GL#',
803: p_id_flex_num => p_chart_of_acct_id,
804: p_qualifier => 'ALL',

Line 807: h_dist_natacct := fa_rx_flex_pkg.get_value(

803: p_id_flex_num => p_chart_of_acct_id,
804: p_qualifier => 'ALL',
805: p_data => h_dist_acct);
806:
807: h_dist_natacct := fa_rx_flex_pkg.get_value(
808: p_application_id => 101,
809: p_id_flex_code => 'GL#',
810: p_id_flex_num => p_chart_of_acct_id,
811: p_qualifier => 'GL_ACCOUNT',

Line 814: h_dist_natdesc := fa_rx_flex_pkg.get_description(

810: p_id_flex_num => p_chart_of_acct_id,
811: p_qualifier => 'GL_ACCOUNT',
812: p_ccid => h_dist_ccid);
813:
814: h_dist_natdesc := fa_rx_flex_pkg.get_description(
815: p_application_id => 101,
816: p_id_flex_code => 'GL#',
817: p_id_flex_num => p_chart_of_acct_id,
818: p_qualifier => 'GL_ACCOUNT',