APPS.PON_LARGE_AUCTION_UTIL_PKG dependencies on FND_ATTACHED_DOCUMENTS

Line 26: FROM fnd_attached_documents ad

22:
23: -- Determine which lines have attachments
24: CURSOR bid_lines_with_attachments IS
25: SELECT DISTINCT ad.pk3_value
26: FROM fnd_attached_documents ad
27: WHERE ad.entity_name = 'PON_BID_ITEM_PRICES'
28: AND ad.pk1_value = p_auc_header_id
29: AND ad.pk2_value = p_bid_number
30: AND ad.pk3_value IS NOT null

Line 38: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

34:
35: -- Delete all line level attachments
36: FOR line IN bid_lines_with_attachments LOOP
37:
38: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
39: (x_entity_name => 'PON_BID_ITEM_PRICES',
40: x_pk1_value => p_auc_header_id,
41: x_pk2_value => p_bid_number,
42: x_pk3_value => line.pk3_value,

Line 65: FROM fnd_attached_documents ad,

61: l_module_name VARCHAR2 (30);
62:
63: CURSOR bid_payments_with_attachments IS
64: SELECT pay.bid_payment_id, pay.bid_number, pay.bid_line_number
65: FROM fnd_attached_documents ad,
66: pon_bid_payments_shipments pay
67: WHERE ad.entity_name = 'PON_BID_PAYMENTS_SHIPMENTS'
68: AND ad.pk1_value = pay.bid_number
69: AND ad.pk2_value = pay.bid_line_number

Line 90: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

86: message => 'Deleting fnd attachments for bid payment id ' ||payment.bid_payment_id||'='|| l_module_name);
87: END IF;
88:
89:
90: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
91: (x_entity_name => 'PON_BID_PAYMENTS_SHIPMENTS',
92: x_pk1_value => payment.bid_number,
93: x_pk2_value => payment.bid_line_number,
94: x_pk3_value => payment.bid_payment_id,

Line 101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);

97:
98: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
99: FND_LOG.string (log_level => FND_LOG.level_procedure,
100: module => g_module_prefix || l_module_name,
101: message => 'After Call FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS = ' || l_module_name);
102: END IF;
103:
104: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
105: FND_LOG.string (log_level => FND_LOG.level_procedure,

Line 1056: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

1052: ) IS
1053: BEGIN
1054:
1055: -- Delete bid header attachment
1056: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
1057: (x_entity_name => 'PON_BID_HEADERS',
1058: x_pk1_value => p_auc_header_id,
1059: x_pk2_value => p_bid_number,
1060: x_delete_document_flag => 'Y');