DBA Data[Home] [Help]

APPS.PON_VALIDATE_PAYMENTS_INT dependencies on FND_ATTACHED_DOCUMENTS

Line 1337: FROM FND_ATTACHED_DOCUMENTS fnd

1333: CURSOR delete_pymt_attachments_cursor IS
1334: SELECT fnd.pk3_value bid_payment_id, -- bid payment id
1335: fnd.pk1_value bid_number, -- bid number
1336: fnd.pk2_value bid_line_number -- bid line number
1337: FROM FND_ATTACHED_DOCUMENTS fnd
1338: WHERE fnd.pk1_value = p_bid_number
1339: AND fnd.pk3_value NOT IN (SELECT bid_payment_id
1340: FROM PON_BID_PAYMENTS_SHIPMENTS pbps
1341: WHERE pbps.bid_number = p_bid_number)

Line 1527: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS

1523:
1524: -- To delete attachments of pon_bid_payments_shipments
1525: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor
1526: LOOP
1527: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS
1528: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
1529: x_pk1_value => delete_pymt_attachments_record.bid_number,
1530: x_pk2_value => delete_pymt_attachments_record.bid_line_number,
1531: x_pk3_value => delete_pymt_attachments_record.bid_payment_id);