DBA Data[Home] [Help]

APPS.ARRX_OTH dependencies on FA_RX_FLEX_PKG

Line 230: FA_RX_FLEX_PKG.FLEX_SQL(

226: IF OPER IS NULL THEN
227: CO_SEG_WHERE := NULL;
228: ELSE
229: CO_SEG_WHERE := ' AND '||
230: FA_RX_FLEX_PKG.FLEX_SQL(
231: p_application_id => 101,
232: p_id_flex_code => 'GL#',
233: p_id_flex_num => var.chart_of_accounts_id,
234: p_table_alias => 'glc',

Line 347: ACCT_FLEX := 'FA_RX_FLEX_PKG.GET_VALUE(101,''GL#'',GLS.CHART_OF_ACCOUNTS_ID, ''ALL'',APP.CODE_COMBINATION_ID) ACCOUNTING_FLEX_FIELD ';

343: APP_TYPE_WHERE := ' AND PS.TRX_NUMBER = :p_app_type';
344: END IF;
345:
346: -- DECODE/LONG statements
347: ACCT_FLEX := 'FA_RX_FLEX_PKG.GET_VALUE(101,''GL#'',GLS.CHART_OF_ACCOUNTS_ID, ''ALL'',APP.CODE_COMBINATION_ID) ACCOUNTING_FLEX_FIELD ';
348: DECODE_ACT_NAME := 'DECODE(SIGN(APP.APPLIED_PAYMENT_SCHEDULE_ID), -1, ' ||
349: ' arpt_sql_func_util.get_rec_trx_type(app.receivables_trx_id,''NAME''),NULL)';
350: DECODE_REF_TYPE := 'arpt_sql_func_util.get_lookup_meaning(DECODE(APP.APPLIED_PAYMENT_SCHEDULE_ID, -7, ''AR_PREPAYMENT_TYPE'', ' ||
351: ' ''APPLICATION_REF_TYPE''), APP.APPLICATION_REF_TYPE) ';

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

593: --
594: -- Assign acount data
595: --
596:
597: var.debit_balancing := fa_rx_flex_pkg.get_value(
598: p_application_id => 101,
599: p_id_flex_code => 'GL#',
600: p_id_flex_num => var.chart_of_accounts_id,
601: p_qualifier => 'GL_BALANCING',