DBA Data[Home] [Help]

APPS.FUN_NET_AP_INVS_PKG dependencies on FUN_NET_AP_INVS_ALL

Line 40: INSERT INTO fun_net_ap_invs_all (

36: ) IS
37:
38: BEGIN
39:
40: INSERT INTO fun_net_ap_invs_all (
41: batch_id,
42: invoice_id,
43: object_version_number,
44: ap_txn_rank,

Line 157: UPDATE fun_net_ap_invs_all SET

153: ) IS
154:
155: BEGIN
156:
157: UPDATE fun_net_ap_invs_all SET
158: batch_id = x_batch_id,
159: invoice_id = x_invoice_id,
160: object_version_number = x_object_version_number,
161: ap_txn_rank = x_ap_txn_rank,

Line 298: FROM fun_net_ap_invs_all

294: x_attribute17,
295: x_attribute18,
296: x_attribute19,
297: x_attribute20
298: FROM fun_net_ap_invs_all
299: WHERE batch_id = x_batch_id
300: AND invoice_id = x_invoice_id;
301:
302: IF ( SQL%NOTFOUND ) THEN

Line 316: DELETE fun_net_ap_invs_all

312: ) IS
313:
314: BEGIN
315:
316: DELETE fun_net_ap_invs_all
317: WHERE batch_id = x_batch_id
318: AND invoice_id = x_invoice_id;
319:
320: IF ( SQL%NOTFOUND ) THEN