APPS.XTR_ORACLE_FIN_INTERFACES_P dependencies on XTR_COMPANY_PARAMETERS

Line 196: FROM XTR_COMPANY_PARAMETERS WHERE

192:
193: Cursor CHK_ALLOW_UNBAL_JRNL is
194: Select
195: PARAMETER_VALUE_CODE
196: FROM XTR_COMPANY_PARAMETERS WHERE
197: COMPANY_CODE in (Select distinct company_code from xtr_journals
198: where batch_id = in_batch_id)
199: and parameter_code = 'ACCNT_UNBAL';
200:

Line 313: l_param_code XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := 'N';

309: |----------------------------------------------------------------------*/
310:
311: FUNCTION GET_UNBALANCE_PARAM (in_company IN VARCHAR2) RETURN VARCHAR2 IS
312:
313: l_param_code XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := 'N';
314:
315: Cursor UNBAL_PARAM is
316: Select parameter_value_code
317: from XTR_COMPANY_PARAMETERS

Line 317: from XTR_COMPANY_PARAMETERS

313: l_param_code XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := 'N';
314:
315: Cursor UNBAL_PARAM is
316: Select parameter_value_code
317: from XTR_COMPANY_PARAMETERS
318: where company_code = in_company
319: and parameter_code = 'ACCNT_UNBAL';
320: --
321:

Line 373: l_trx_param xtr_company_parameters.parameter_value_code%TYPE;

369: -- Oracle Financials GL_INTERFACE Table
370: --
371:
372: l_set_of_books gl_sets_of_books.set_of_books_id%TYPE := to_number(NULL);
373: l_trx_param xtr_company_parameters.parameter_value_code%TYPE;
374: l_source_name gl_je_sources.user_je_source_name%TYPE;
375: l_category_name gl_je_categories.user_je_category_name%TYPE;
376: l_xchange_type gl_daily_conversion_types.user_conversion_type%TYPE;
377: l_gl_link_id XTR_JOURNALS.gl_sl_link_id%TYPE;

Line 382: l_bal_flag XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;

378: l_gl_group_id GL_INTERFACE.group_id%TYPE; -- add to record group id when tranfer
379: p_company_code XTR_PARTY_INFO.party_code%TYPE;
380: l_rowid VARCHAR2(30);
381:
382: l_bal_flag XTR_COMPANY_PARAMETERS.parameter_value_code%TYPE := NULL;
383: l_ok_to_xfer BOOLEAN := FALSE;
384: l_sob_name GL_SETS_OF_BOOKS.name%TYPE := NULL;
385: l_journal_date DATE := to_date(null);
386: l_next_open_start DATE := to_date(null);

Line 398: from XTR_COMPANY_PARAMETERS

394: and PTY.party_code = p_company_code;
395: --
396: cursor TRX_PARAM is
397: select parameter_value_code
398: from XTR_COMPANY_PARAMETERS
399: where company_code = p_company_code
400: and parameter_code = 'ACCNT_JNTRM';-- determine the transfer method: SUMMARY or DETAIL
401:
402: cursor JNL_SUMMARY is