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.44 2011/03/10 12:23:16 abhaktha ship $ */
3:
4: FUNCTION has_valid_conversion_rate (
5: p_from_currency IN varchar2,

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

161: l_cur_select := 'SELECT
162: trxH.status status,
163: gt.party_type_flag party_type_flag,
164: Nvl(nvl(decode(glps.closing_status,''O'','''',''F'','''', ''GL_PERIOD_NOT_OPEN''),
165: decode(FUN_GL_BATCH_TRANSFER.has_valid_conversion_rate(trxB.currency_code,ledgers.currency_code,
166: trxB.exchange_rate_type,TRUNC(trxB.GL_DATE)),1,'''',0,''FUN_API_CONV_RATE_NOT_FOUND'')),
167: ''FUN_API_TRX_TRANSFERRED'') error_mesg,
168: gt.trx_id trx_id,
169: trxH.trx_number trx_number,

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

357: ''A'','''||
358: l_category||''','''||
359: l_source||''',
360: TRUNC(TRXB.GL_DATE),
361: FUN_GL_BATCH_TRANSFER.GET_CONVERSION_TYPE(TRXB.EXCHANGE_RATE_TYPE),
362: D.AMOUNT_DR,
363: D.AMOUNT_CR,
364: D.DESCRIPTION,
365: TRXB.DESCRIPTION,

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

394: AND T.TRX_ID = GT.TRX_ID
395: AND D.TRX_ID = T.TRX_ID
396: AND D.PARTY_TYPE_FLAG = GT.PARTY_TYPE_FLAG
397: AND GLPS.CLOSING_STATUS IN (''O'',''F'')
398: AND FUN_GL_BATCH_TRANSFER.HAS_VALID_CONVERSION_RATE(TRXB.CURRENCY_CODE,LEDGERS.CURRENCY_CODE,
399: TRXB.EXCHANGE_RATE_TYPE,TRUNC(TRXB.GL_DATE)) = 1';
400:
401: l_cur_main_query := l_cur_select||l_cur_where;
402:

Line 591: END FUN_GL_BATCH_TRANSFER;

587: commit;
588:
589: END GL_BATCH_TRANSFER;
590:
591: END FUN_GL_BATCH_TRANSFER;
592:
593: