APPS.PO_MULTI_MOD_PVT dependencies on PO_MULTI_MOD_CHANGES

Line 64: debug(d_module, d_position, 'Deleting redundant entries from po_multi_mod_changes');

60: PO_LOG.proc_begin(d_module,'p_multi_mod_request_id',p_multi_mod_request_id);
61: END IF;
62:
63: d_position := 10;
64: debug(d_module, d_position, 'Deleting redundant entries from po_multi_mod_changes');
65:
66: DELETE
67: FROM po_multi_mod_changes
68: WHERE multi_mod_request_id = p_multi_mod_request_id

Line 67: FROM po_multi_mod_changes

63: d_position := 10;
64: debug(d_module, d_position, 'Deleting redundant entries from po_multi_mod_changes');
65:
66: DELETE
67: FROM po_multi_mod_changes
68: WHERE multi_mod_request_id = p_multi_mod_request_id
69: AND ((change_type = 'VENDOR_SITE_CONTACT'
70: AND (org_id, old_vendor_site_id) NOT IN
71: (SELECT DISTINCT org_id, vendor_site_id

Line 148: -- po_multi_mod_changes and po_multi_mod_requests

144: -- None.
145: --Function:
146: -- Removes the multi_mod_request
147: -- Deletes entries from po_multi_mod_val_results, po_multi_mod_docs,
148: -- po_multi_mod_changes and po_multi_mod_requests
149: --Parameters:
150: --IN:
151: --p_multi_mod_request_id
152: -- The request id of the Multi-Mod Request

Line 178: DELETE FROM po_multi_mod_changes

174: DELETE FROM po_multi_mod_docs
175: WHERE multi_mod_request_id = p_multi_mod_request_id;
176:
177: -- remove changes made in multi mod request
178: DELETE FROM po_multi_mod_changes
179: WHERE multi_mod_request_id = p_multi_mod_request_id;
180:
181: --remove from po_multi_mod_requests table
182: DELETE FROM po_multi_mod_requests

Line 2178: FROM po_multi_mod_changes

2174: --Get the New Suplier Details one by one:
2175: --1. New Supplier Id
2176: SELECT new_vendor_id, new_vendor_name
2177: INTO l_new_vendor_id, l_new_vendor_name
2178: FROM po_multi_mod_changes
2179: WHERE multi_mod_request_id = p_multi_mod_request_id
2180: AND change_type = 'VENDOR'
2181: AND old_vendor_id = l_old_vendor_id;
2182:

Line 2186: FROM po_multi_mod_changes

2182:
2183: --2. New Supplier Site and Contact
2184: SELECT new_vendor_site_id, new_vendor_contact_id
2185: INTO l_new_vendor_site_id, l_new_vendor_contact_id
2186: FROM po_multi_mod_changes
2187: WHERE multi_mod_request_id = p_multi_mod_request_id
2188: AND change_type = 'VENDOR_SITE_CONTACT'
2189: AND org_id = l_org_id
2190: AND old_vendor_site_id = l_old_vendor_site_id;

Line 2196: FROM po_multi_mod_changes

2192: --3. New Remit to Address
2193: BEGIN
2194: SELECT new_remit_to_addr
2195: INTO l_new_remit_to_addr
2196: FROM po_multi_mod_changes
2197: WHERE multi_mod_request_id = p_multi_mod_request_id
2198: AND change_type = 'VENDOR_REMIT_ADDRESS'
2199: AND old_remit_to_addr = l_old_remit_to_addr
2200: AND org_id = l_org_id;

Line 2302: po_multi_mod_changes PMMC

2298: FND_GLOBAL.login_id,
2299: SYSDATE,
2300: FND_GLOBAL.user_id
2301: FROM po_ga_org_assignments PGOA,
2302: po_multi_mod_changes PMMC
2303: WHERE PGOA.po_header_id = p_po_header_id
2304: AND PMMC.org_id = PGOA.purchasing_org_id
2305: AND PMMC.old_vendor_site_id = PGOA.vendor_site_id
2306: AND PMMC.change_type = 'VENDOR_SITE_CONTACT'