APPS.FUN_NET_ARAP_PKG dependencies on FUN_NET_ARAP_PKG

Line 1: PACKAGE BODY fun_net_arap_pkg AS

1: PACKAGE BODY fun_net_arap_pkg AS
2: /* $Header: funnttxb.pls 120.112.12020000.3 2012/12/19 06:42:01 srampure ship $ */
3: --===========================FND_LOG.START=====================================
4: g_state_level NUMBER;
5: g_proc_level NUMBER;

Line 490: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,

486: IF l_allow_disc_flag='N' THEN -- FOR NON ESD AGREEMENTS
487: -- Build Select Clause --
488: l_trx_select_clause :=
489: 'SELECT rct.customer_trx_id,
490: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
491: sum(arps.amount_due_remaining) AS open_amount ' ;
492: ELSE -- FOR ESD Enabled Agreements, Calculating OPEN_AMOUNT_AFTERDISC for ESD enabled Agreements
493: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id); -- chk pending where to put the MOAC call.
494: l_trx_select_clause :=

Line 496: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,

492: ELSE -- FOR ESD Enabled Agreements, Calculating OPEN_AMOUNT_AFTERDISC for ESD enabled Agreements
493: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id); -- chk pending where to put the MOAC call.
494: l_trx_select_clause :=
495: 'SELECT rct.customer_trx_id,
496: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
497: sum(arps.amount_due_remaining) AS open_amount,
498: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
499: END IF;
500: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);

Line 617: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,

613: fun_net_util.Log_String(g_state_level,l_path,'g_batch_details.exchange_rate_type :' ||g_batch_details.exchange_rate_type);
614: IF l_allow_disc_flag='N' THEN -- FOR NON ESD AGREEMENTS
615: l_trx_select_clause :=
616: 'SELECT rct.customer_trx_id,
617: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
618: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,
619: :batch_currency,
620: trunc(:SETTLEMENT_DATE),
621: :exchange_rate_type,

Line 629: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,

625: sum(arps.amount_due_remaining) AS txn_curr_open_amt ' ;
626: ELSE -- FOR ESD ENABLED AGREEMENTS,Calculating OPEN_AMOUNT_AFTERDISC for ESD enabled Agreements
627: l_trx_select_clause :=
628: 'SELECT rct.customer_trx_id,
629: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
630: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,
631: :batch_currency,
632: trunc(:SETTLEMENT_DATE),
633: :exchange_rate_type,

Line 4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';

4910: g_event_level := FND_LOG.LEVEL_EVENT;
4911: g_excep_level := FND_LOG.LEVEL_EXCEPTION;
4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4916: END FUN_NET_ARAP_PKG;

Line 4916: END FUN_NET_ARAP_PKG;

4912: g_error_level := FND_LOG.LEVEL_ERROR;
4913: g_unexp_level := FND_LOG.LEVEL_UNEXPECTED;
4914: g_path := 'FUN.PLSQL.funnttxb.FUN_NET_ARAP_PKG.';
4915: --===========================FND_LOG.END=======================================
4916: END FUN_NET_ARAP_PKG;