APPS.PO_VENDORMERGE_GRP dependencies on PO_AUTOSOURCE_DOCUMENTS

Line 54: from po_autosource_documents pad

50: cursor merge_autosrc_docs is
51: select distinct pad.autosource_rule_id,
52: pad.sequence_num,
53: pad.document_line_id
54: from po_autosource_documents pad
55: where pad.vendor_id = p_dup_vendor_id;
56:
57: l_api_name CONSTANT VARCHAR2(30) := 'Merge_Vendor';
58: l_api_version CONSTANT NUMBER := 1.0;

Line 221: -- modify po_autosource_documents

217: IF (PO_LOG.d_stmt) THEN
218: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_VENDORS');
219: END IF;
220:
221: -- modify po_autosource_documents
222: --
223: open merge_autosrc_docs;
224:
225: loop

Line 234: from po_autosource_documents

230: exit when merge_autosrc_docs%notfound;
231:
232: select nvl(max(sequence_num),0)
233: into l_max_seq_num
234: from po_autosource_documents
235: where autosource_rule_id = l_rule_id
236: and vendor_id = p_vendor_id;
237:
238: l_new_seq_num := l_max_seq_num + 1;

Line 240: update po_autosource_documents

236: and vendor_id = p_vendor_id;
237:
238: l_new_seq_num := l_max_seq_num + 1;
239:
240: update po_autosource_documents
241: set vendor_id = p_vendor_id,
242: sequence_num = l_new_seq_num
243: where autosource_rule_id = l_rule_id
244: and vendor_id = p_dup_vendor_id

Line 248: from po_autosource_documents

244: and vendor_id = p_dup_vendor_id
245: and sequence_num = l_seq_num
246: and not exists
247: (select 'already have PAD for this rule, vendor, doc line'
248: from po_autosource_documents
249: where autosource_rule_id = l_rule_id
250: and vendor_id = p_vendor_id
251: and document_line_id = l_doc_line_id);
252:

Line 263: delete from po_autosource_documents

259:
260:
261: IF (p_dup_vendor_id <> p_vendor_id) Then
262:
263: delete from po_autosource_documents
264: where vendor_id = p_dup_vendor_id;
265:
266: End If;
267:

Line 269: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_DOCUMENTS');

265:
266: End If;
267:
268: IF (PO_LOG.d_stmt) THEN
269: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_DOCUMENTS');
270: END IF;
271:
272: -- Starting from 11i FPJ we no longer update ga org assignments based on
273: -- vendor site code. Instead we just need to update org assignment with