APPS.FUN_GL_BATCH_TRANSFER dependencies on FUN_GL_BATCH_TRANSFER

Line 1: PACKAGE BODY FUN_GL_BATCH_TRANSFER AS

1: PACKAGE BODY FUN_GL_BATCH_TRANSFER AS
2: /* $Header: FUNGLTRB.pls 120.32.12010000.7 2008/10/27 08:24:20 makansal ship $ */
3:
4: FUNCTION has_valid_conversion_rate (
5: p_from_currency IN varchar2,

Line 157: decode(FUN_GL_BATCH_TRANSFER.has_valid_conversion_rate(trxB.currency_code,ledgers.currency_code,

153: l_cur_select := 'SELECT
154: trxH.status status,
155: gt.party_type_flag party_type_flag,
156: Nvl(nvl(decode(glps.closing_status,''O'','''',''F'','''', ''GL_PERIOD_NOT_OPEN''),
157: decode(FUN_GL_BATCH_TRANSFER.has_valid_conversion_rate(trxB.currency_code,ledgers.currency_code,
158: trxB.exchange_rate_type,TRUNC(trxB.batch_date)),1,'''',0,''FUN_API_CONV_RATE_NOT_FOUND'')),
159: ''FUN_API_TRX_TRANSFERRED'') error_mesg,
160: gt.trx_id trx_id,
161: trxH.trx_number trx_number,

Line 352: FUN_GL_BATCH_TRANSFER.GET_CONVERSION_TYPE(TRXB.EXCHANGE_RATE_TYPE),

348: ''A'','''||
349: l_category||''','''||
350: l_source||''',
351: TRUNC(TRXB.GL_DATE),
352: FUN_GL_BATCH_TRANSFER.GET_CONVERSION_TYPE(TRXB.EXCHANGE_RATE_TYPE),
353: D.AMOUNT_DR,
354: D.AMOUNT_CR,
355: GT.DESCRIPTION,
356: D.CCID,

Line 388: AND FUN_GL_BATCH_TRANSFER.HAS_VALID_CONVERSION_RATE(TRXB.CURRENCY_CODE,LEDGERS.CURRENCY_CODE,

384: AND T.TRX_ID = GT.TRX_ID
385: AND D.TRX_ID = T.TRX_ID
386: AND D.PARTY_TYPE_FLAG = GT.PARTY_TYPE_FLAG
387: AND GLPS.CLOSING_STATUS IN (''O'',''F'')
388: AND FUN_GL_BATCH_TRANSFER.HAS_VALID_CONVERSION_RATE(TRXB.CURRENCY_CODE,LEDGERS.CURRENCY_CODE,
389: TRXB.EXCHANGE_RATE_TYPE,TRUNC(TRXB.BATCH_DATE)) = 1';
390:
391: l_cur_main_query := l_cur_select||l_cur_where;
392:

Line 581: END FUN_GL_BATCH_TRANSFER;

577: commit;
578:
579: END GL_BATCH_TRANSFER;
580:
581: END FUN_GL_BATCH_TRANSFER;
582:
583: