APPS.PO_VENDORMERGE_GRP dependencies on PO_AUTOSOURCE_VENDORS

Line 174: -- modify PO_AUTOSOURCE_VENDORS

170: IF (PO_LOG.d_stmt) THEN
171: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
172: END IF;
173:
174: -- modify PO_AUTOSOURCE_VENDORS
175: UPDATE po_autosource_vendors pav1
176: SET pav1.vendor_id = p_vendor_id
177: WHERE pav1.vendor_id = p_dup_vendor_id
178: AND not exists

Line 175: UPDATE po_autosource_vendors pav1

171: PO_LOG.stmt(d_module, d_progress, 'updated PO_VENDOR_LIST_ENTRIES');
172: END IF;
173:
174: -- modify PO_AUTOSOURCE_VENDORS
175: UPDATE po_autosource_vendors pav1
176: SET pav1.vendor_id = p_vendor_id
177: WHERE pav1.vendor_id = p_dup_vendor_id
178: AND not exists
179: (select vendor_id

Line 180: from po_autosource_vendors pav2

176: SET pav1.vendor_id = p_vendor_id
177: WHERE pav1.vendor_id = p_dup_vendor_id
178: AND not exists
179: (select vendor_id
180: from po_autosource_vendors pav2
181: where pav2.vendor_id = p_vendor_id
182: and pav2.autosource_rule_id =
183: pav1.autosource_rule_id) ;
184:

Line 187: UPDATE po_autosource_vendors pav1

183: pav1.autosource_rule_id) ;
184:
185:
186: -- modify split
187: UPDATE po_autosource_vendors pav1
188: SET pav1.split = (SELECT sum (pav3.split)
189: FROM po_autosource_vendors pav3
190: WHERE pav3.autosource_rule_id =
191: pav1.autosource_rule_id

Line 189: FROM po_autosource_vendors pav3

185:
186: -- modify split
187: UPDATE po_autosource_vendors pav1
188: SET pav1.split = (SELECT sum (pav3.split)
189: FROM po_autosource_vendors pav3
190: WHERE pav3.autosource_rule_id =
191: pav1.autosource_rule_id
192: AND pav3.vendor_id IN
193: (p_vendor_id, p_dup_vendor_id))

Line 197: from po_autosource_vendors pav2

193: (p_vendor_id, p_dup_vendor_id))
194: WHERE pav1.vendor_id = p_vendor_id
195: AND exists
196: (select pav2.vendor_id
197: from po_autosource_vendors pav2
198: where pav2.vendor_id = p_dup_vendor_id
199: and pav2.autosource_rule_id =
200: pav1.autosource_rule_id) ;
201:

Line 212: DELETE from po_autosource_vendors pavl

208:
209:
210: IF (p_dup_vendor_id <> p_vendor_id) THEN
211:
212: DELETE from po_autosource_vendors pavl
213: WHERE vendor_id = p_dup_vendor_id ;
214:
215: END IF;
216:

Line 218: PO_LOG.stmt(d_module, d_progress, 'updated PO_AUTOSOURCE_VENDORS');

214:
215: END IF;
216:
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: --