DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on MO_GLOBAL

Line 263: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);

259: SELECT
260: DISTINCT ORG_ID INTO l_org_id
261: FROM FUN_NET_AR_TXNS_ALL
262: WHERE CUSTOMER_TRX_ID = p_cust_txn_id;
263: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
264: IF(l_net_currency_rule_code = 'ACCOUNTING_CURRENCY') THEN
265: l_amt_to_net := Derive_Conv_Amt(p_batch_id, p_cust_txn_id, l_amt_to_net, 'AR');
266: fun_net_util.Log_String(g_state_level,l_path,'After conversion :'|| l_amt_to_net);
267: END IF;

Line 493: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id); -- chk pending where to put the MOAC call.

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 :=
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,

Line 1743: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id);

1739: END IF;
1740: END LOOP;
1741: ELSE
1742: fun_net_util.Log_String(g_state_level,l_path,'Inside ELSE condition');
1743: MO_GLOBAL.SET_POLICY_CONTEXT('S',g_batch_details.org_id);
1744: l_sql_stmt:='SELECT PAYMENT_SCHEDULE_ID,AMOUNT_DUE_REMAINING FROM ar_payment_schedules_all WHERE CUSTOMER_TRX_ID=:v_cst_trx_id';
1745: l_applieddisc(i):=0;
1746: OPEN pmt_rec FOR l_sql_stmt USING l_trx_id(i);
1747: FETCH pmt_rec BULK COLLECT INTO l_pmtno,l_amt_remaining;