APPS.FUN_NET_CANCEL_PKG dependencies on FUN_NET_AR_TXNS

Line 140: TYPE l_txn_tab_type IS TABLE OF fun_net_ar_txns.customer_trx_id%TYPE;

136: PROCEDURE delete_ar_txns (
137: x_batch_id IN fun_net_batches.batch_id%TYPE,
138: x_return_status OUT NOCOPY VARCHAR2)
139: IS
140: TYPE l_txn_tab_type IS TABLE OF fun_net_ar_txns.customer_trx_id%TYPE;
141: l_txn_tab l_txn_tab_type;
142:
143: BEGIN
144: x_return_status := FND_API.G_TRUE;

Line 147: FROM fun_net_ar_txns

143: BEGIN
144: x_return_status := FND_API.G_TRUE;
145: SELECT customer_trx_id
146: BULK COLLECT INTO l_txn_tab
147: FROM fun_net_ar_txns
148: WHERE batch_id = x_batch_id;
149:
150: IF l_txn_tab.EXISTS(1) THEN
151:

Line 154: FUN_NET_AR_TXNS_PKG.Delete_Row(

150: IF l_txn_tab.EXISTS(1) THEN
151:
152: FOR i IN l_txn_tab.FIRST..l_txn_tab.LAST
153: LOOP
154: FUN_NET_AR_TXNS_PKG.Delete_Row(
155: x_batch_id => x_batch_id,
156: x_customer_trx_id => l_txn_tab(i));
157: END LOOP;
158: END IF;

Line 491: fun_net_ar_txns txn,

487: cr.receipt_number,
488: cr.receipt_date,
489: txn.org_id
490: FROM
491: fun_net_ar_txns txn,
492: ar_cash_receipts_all cr
493: WHERE txn.batch_id = p_batch_id
494: AND txn.cash_receipt_id = cr.cash_receipt_id
495: AND txn.org_id = cr.org_id;

Line 609: UPDATE FUN_NET_AR_TXNS

605: x_return_status := FND_API.G_FALSE;
606: RETURN;
607: END;
608: BEGIN
609: UPDATE FUN_NET_AR_TXNS
610: SET netted_amt = 0
611: WHERE batch_id = p_batch_id;
612: EXCEPTION
613: WHEN OTHERS THEN