APPS.PO_DRAFT_MERGE_PKG dependencies on PO_ENTITY_LOCKS

Line 274: FROM po_entity_locks

270: SELECT 'Y'
271: INTO l_attach_locks_exist
272: FROM DUAL
273: WHERE EXISTS (SELECT 'attachment locks exist'
274: FROM po_entity_locks
275: WHERE lock_by_draft_id = p_draft_id
276: AND entity_name IN ('PO_HEADERS_ATTACH','PO_LINES_ATTACH','PO_LINE_LOCATIONS_ATTACH'));
277:
278: EXCEPTION

Line 283: -- TThe upgrade script will add locks in po_entity_locks table.

279: WHEN NO_DATA_FOUND then null;
280: END;
281:
282: -- check if the attachments are upgraded attachments or not
283: -- TThe upgrade script will add locks in po_entity_locks table.
284: -- But the Orig Attach Id of these attachments will be NULL.
285: -- If the above two conditions are satisfied then , it is the case of
286: -- upgraded attachments
287: IF l_attach_locks_exist = 'Y' AND l_attach_with_orig_attach_id = 'N' THEN

Line 1433: -- po_entity_locks

1429: --Name: delete_entity_locks
1430: --
1431: --Pre-reqs: None
1432: --Modifies:
1433: -- po_entity_locks
1434: --Function:
1435: -- This procedure deletes records from po_entity_locks for the given p_draft_id
1436: --Parameters:
1437: --IN:

Line 1435: -- This procedure deletes records from po_entity_locks for the given p_draft_id

1431: --Pre-reqs: None
1432: --Modifies:
1433: -- po_entity_locks
1434: --Function:
1435: -- This procedure deletes records from po_entity_locks for the given p_draft_id
1436: --Parameters:
1437: --IN:
1438: --p_draft_id
1439: -- draft id of the current Modification - Award/IDV

Line 1451: DELETE FROM po_entity_locks

1447: ,x_return_status IN OUT NOCOPY VARCHAR2)
1448: IS
1449: BEGIN
1450:
1451: DELETE FROM po_entity_locks
1452: WHERE lock_by_draft_id = p_draft_id;
1453:
1454: -- TODO: Add call to OKC procedure to delete OKC locks for the Modification
1455: