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 519: fun_net_ar_txns txn,

515: cr.receipt_number,
516: cr.receipt_date,
517: txn.org_id
518: FROM
519: fun_net_ar_txns txn,
520: ar_cash_receipts_all cr
521: WHERE txn.batch_id = p_batch_id
522: AND txn.cash_receipt_id = cr.cash_receipt_id
523: AND txn.org_id = cr.org_id;

Line 640: UPDATE FUN_NET_AR_TXNS

636: x_return_status := FND_API.G_FALSE;
637: RETURN;
638: END;
639: BEGIN
640: UPDATE FUN_NET_AR_TXNS
641: SET netted_amt = 0
642: WHERE batch_id = p_batch_id;
643: EXCEPTION
644: WHEN OTHERS THEN