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 = ''REC'' ' ||' and glc.code_combination_id = dist.code_combination_id and glc.chart_of_accounts_id = ' ||
65: coa_id || ' ' || co_seg_where;
66:

Line 397: FA_RX_FLEX_PKG.FLEX_SQL(

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

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

836: -- Assign acount data
837: --
838:
839: /*
840: var.debit_account := fa_rx_flex_pkg.get_value(
841: p_application_id => 101,
842: p_id_flex_code => 'GL#',
843: p_id_flex_num => var.chart_of_accounts_id,
844: p_qualifier => 'ALL',

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

843: p_id_flex_num => var.chart_of_accounts_id,
844: p_qualifier => 'ALL',
845: p_ccid => var.account_code_combination_id);
846:
847: var.debit_account_desc := substrb(fa_rx_flex_pkg.get_description(
848: p_application_id => 101,
849: p_id_flex_code => 'GL#',
850: p_id_flex_num => var.chart_of_accounts_id,
851: p_qualifier => 'ALL',

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

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

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

858: p_id_flex_num => var.chart_of_accounts_id,
859: p_qualifier => 'GL_BALANCING',
860: p_ccid => var.account_code_combination_id);
861:
862: var.debit_balancing_desc:= substrb(fa_rx_flex_pkg.get_description(
863: p_application_id => 101,
864: p_id_flex_code => 'GL#',
865: p_id_flex_num => var.chart_of_accounts_id,
866: p_qualifier => 'GL_BALANCING',

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

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

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

872: p_id_flex_num => var.chart_of_accounts_id,
873: p_qualifier => 'GL_ACCOUNT',
874: p_ccid => var.account_code_combination_id);
875:
876: var.debit_natacct_desc := substrb(fa_rx_flex_pkg.get_description(
877: p_application_id => 101,
878: p_id_flex_code => 'GL#',
879: p_id_flex_num => var.chart_of_accounts_id,
880: p_qualifier => 'GL_ACCOUNT',