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 287: -- modify po_autosource_documents

283: IF (PO_LOG.d_stmt) THEN
284: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_VENDORS');
285: END IF;
286:
287: -- modify po_autosource_documents
288: --
289: open merge_autosrc_docs;
290:
291: loop

Line 300: from po_autosource_documents

296: exit when merge_autosrc_docs%notfound;
297:
298: select nvl(max(sequence_num),0)
299: into l_max_seq_num
300: from po_autosource_documents
301: where autosource_rule_id = l_rule_id
302: and vendor_id = p_vendor_id;
303:
304: l_new_seq_num := l_max_seq_num + 1;

Line 306: update po_autosource_documents

302: and vendor_id = p_vendor_id;
303:
304: l_new_seq_num := l_max_seq_num + 1;
305:
306: update po_autosource_documents
307: set vendor_id = p_vendor_id,
308: sequence_num = l_new_seq_num
309: where autosource_rule_id = l_rule_id
310: and vendor_id = p_dup_vendor_id

Line 314: from po_autosource_documents

310: and vendor_id = p_dup_vendor_id
311: and sequence_num = l_seq_num
312: and not exists
313: (select 'already have PAD for this rule, vendor, doc line'
314: from po_autosource_documents
315: where autosource_rule_id = l_rule_id
316: and vendor_id = p_vendor_id
317: and document_line_id = l_doc_line_id);
318:

Line 329: delete from po_autosource_documents

325:
326:
327: IF (p_dup_vendor_id <> p_vendor_id) Then
328:
329: delete from po_autosource_documents
330: where vendor_id = p_dup_vendor_id;
331:
332: End If;
333:

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

331:
332: End If;
333:
334: IF (PO_LOG.d_stmt) THEN
335: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_DOCUMENTS');
336: END IF;
337:
338: -- Starting from 11i FPJ we no longer update ga org assignments based on
339: -- vendor site code. Instead we just need to update org assignment with