APPS.PO_MULTI_MOD_PVT dependencies on PO_MULTI_MOD_VAL_RESULTS

Line 107: FROM po_multi_mod_val_results pmmvr

103: d_position := 30;
104: debug(d_module, d_position, 'Deleting redundant entries from po_multi_val_results');
105:
106: DELETE
107: FROM po_multi_mod_val_results pmmvr
108: WHERE multi_mod_request_id = p_multi_mod_request_id
109: AND multi_mod_doc_id IS NOT NULL -- Remove only document-level exceptions
110: AND NOT EXISTS(
111: SELECT 1

Line 147: -- Deletes entries from po_multi_mod_val_results, po_multi_mod_docs,

143: --Locks:
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

Line 170: DELETE FROM po_multi_mod_val_results

166: PO_LOG.proc_begin(d_module,'p_multi_mod_request_id ',p_multi_mod_request_id);
167: END IF;
168:
169: -- remove all exceptionms occurred in multi mod request
170: DELETE FROM po_multi_mod_val_results
171: WHERE multi_mod_request_id = p_multi_mod_request_id;
172:
173: -- remove all records selected for the multi mod request
174: DELETE FROM po_multi_mod_docs