APPS.PO_CLM_CAR_UTIL dependencies on PO_CLM_CAR_LOGS

Line 271: DELETE FROM PO_CLM_CAR_LOGS

267: AND po_header_id = p_po_header_id
268: AND po_draft_id = NVL(p_po_draft_id, -1);
269:
270: --delete the logs of the car
271: DELETE FROM PO_CLM_CAR_LOGS
272: WHERE car_id = p_car_id
273: AND po_header_id = p_po_header_id
274: AND po_draft_id = NVL(p_po_draft_id, -1);
275:

Line 305: DELETE FROM PO_CLM_CAR_LOGS

301:
302: BEGIN
303: IF p_overwrite = 'T' THEN
304: --we don't keep the old log for the car
305: DELETE FROM PO_CLM_CAR_LOGS
306: WHERE car_id = p_car_id
307: AND po_header_id = p_po_header_id
308: AND po_draft_id = NVL(p_po_draft_id, -1);
309: END IF;

Line 314: INSERT INTO PO_CLM_CAR_LOGS ( car_id,

310:
311: IF p_clm_car_log_tab IS NOT NULL AND p_clm_car_log_tab.COUNT > 0 THEN
312: FOR i in 1 .. p_clm_car_log_tab.COUNT
313: LOOP
314: INSERT INTO PO_CLM_CAR_LOGS ( car_id,
315: po_header_id,
316: po_draft_id,
317: source_transaction,
318: module,