APPS.ARRX_ADJ dependencies on FA_RX_FLEX_PKG

Line 62: l_stmt := 'select FA_RX_FLEX_PKG.GET_VALUE(101,''GL#'', ' || coa_id || ', ''GL_BALANCING'',dist.CODE_COMBINATION_ID), ' ||

58: bal_seg2 varchar2(30);
59: use_ccid number;
60: begin
61:
62: l_stmt := 'select FA_RX_FLEX_PKG.GET_VALUE(101,''GL#'', ' || coa_id || ', ''GL_BALANCING'',dist.CODE_COMBINATION_ID), ' ||
63: ' dist.code_Combination_id from ar_distributions_all dist, gl_code_combinations glc where dist.source_id = ' || adj_id ||
64: ' and dist.source_Table = ''ADJ'' and dist.source_Type in ( ''ADJ'', ''TAX'', ''FINCHRG'', ''DEFERRED_TAX'', ' ||
65: ' ''FINCHRG_NON_REC_TAX'') and glc.code_combination_id = dist.code_combination_id and glc.chart_of_accounts_id = ' ||
66: coa_id || ' ' || co_seg_where;

Line 393: FA_RX_FLEX_PKG.FLEX_SQL(

389: IF OPER IS NULL THEN
390: CO_SEG_WHERE := NULL;
391: ELSE
392: CO_SEG_WHERE := ' AND '||
393: FA_RX_FLEX_PKG.FLEX_SQL(
394: p_application_id => 101,
395: p_id_flex_code => 'GL#',
396: p_id_flex_num => var.chart_of_accounts_id,
397: p_table_alias => 'glc',

Line 836: var.debit_account := fa_rx_flex_pkg.get_value(

832: -- Assign acount data
833: --
834:
835: /*
836: var.debit_account := fa_rx_flex_pkg.get_value(
837: p_application_id => 101,
838: p_id_flex_code => 'GL#',
839: p_id_flex_num => var.chart_of_accounts_id,
840: p_qualifier => 'ALL',

Line 843: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description(

839: p_id_flex_num => var.chart_of_accounts_id,
840: p_qualifier => 'ALL',
841: p_ccid => var.account_code_combination_id);
842:
843: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description(
844: p_application_id => 101,
845: p_id_flex_code => 'GL#',
846: p_id_flex_num => var.chart_of_accounts_id,
847: p_qualifier => 'ALL',

Line 851: var.debit_balancing := fa_rx_flex_pkg.get_value(

847: p_qualifier => 'ALL',
848: p_data => var.debit_account),1,240);
849: */
850:
851: var.debit_balancing := fa_rx_flex_pkg.get_value(
852: p_application_id => 101,
853: p_id_flex_code => 'GL#',
854: p_id_flex_num => var.chart_of_accounts_id,
855: p_qualifier => 'GL_BALANCING',

Line 858: var.debit_balancing_desc:= substrb(fa_rx_flex_pkg.get_description(

854: p_id_flex_num => var.chart_of_accounts_id,
855: p_qualifier => 'GL_BALANCING',
856: p_ccid => var.account_code_combination_id);
857:
858: var.debit_balancing_desc:= substrb(fa_rx_flex_pkg.get_description(
859: p_application_id => 101,
860: p_id_flex_code => 'GL#',
861: p_id_flex_num => var.chart_of_accounts_id,
862: p_qualifier => 'GL_BALANCING',

Line 865: var.debit_natacct := fa_rx_flex_pkg.get_value(

861: p_id_flex_num => var.chart_of_accounts_id,
862: p_qualifier => 'GL_BALANCING',
863: p_data => var.debit_balancing),1,240);
864: /*
865: var.debit_natacct := fa_rx_flex_pkg.get_value(
866: p_application_id => 101,
867: p_id_flex_code => 'GL#',
868: p_id_flex_num => var.chart_of_accounts_id,
869: p_qualifier => 'GL_ACCOUNT',

Line 872: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(

868: p_id_flex_num => var.chart_of_accounts_id,
869: p_qualifier => 'GL_ACCOUNT',
870: p_ccid => var.account_code_combination_id);
871:
872: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
873: p_application_id => 101,
874: p_id_flex_code => 'GL#',
875: p_id_flex_num => var.chart_of_accounts_id,
876: p_qualifier => 'GL_ACCOUNT',