DBA Data[Home] [Help]

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 36: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

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

Line 63: FROM fnd_attached_documents ad,

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

Line 88: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

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

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

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

Line 1042: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments

1038: ) IS
1039: BEGIN
1040:
1041: -- Delete bid header attachment
1042: FND_ATTACHED_DOCUMENTS2_PKG.delete_attachments
1043: (x_entity_name => 'PON_BID_HEADERS',
1044: x_pk1_value => p_auc_header_id,
1045: x_pk2_value => p_bid_number,
1046: x_delete_document_flag => 'Y');