APPS.PO_LOCKS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 91

SELECT NULL
FROM
   PO_REQUISITION_HEADERS_ALL PRH
,  PO_SESSION_GT IDS
WHERE PRH.requisition_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF PRH.requisition_header_id
NOWAIT
;

Line: 102

SELECT NULL
FROM
   PO_RELEASES_ALL POR
,  PO_SESSION_GT IDS
WHERE POR.po_release_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF POR.po_release_id
NOWAIT
;

Line: 113

SELECT NULL
FROM
   PO_HEADERS_ALL POH
,  PO_SESSION_GT IDS
WHERE POH.po_header_id = IDS.num1
AND IDS.key = p_doc_id_key
FOR UPDATE OF POH.po_header_id
NOWAIT
;

Line: 147

SELECT PO_SESSION_GT_S.nextval
INTO l_doc_id_key
FROM DUAL
;

Line: 155

INSERT INTO PO_SESSION_GT ( key, num1 )
VALUES ( l_doc_id_key, l_doc_id_tbl(i) )
;

Line: 277

SELECT NULL
FROM
   PO_REQ_DISTRIBUTIONS_ALL PRD
,  PO_SESSION_GT DIST_IDS
WHERE PRD.distribution_id = DIST_IDS.num1
AND DIST_IDS.key = p_dist_id_key
FOR UPDATE OF PRD.distribution_id
NOWAIT
;

Line: 288

SELECT NULL
FROM
   PO_DISTRIBUTIONS_ALL POD
,  PO_SESSION_GT DIST_IDS
WHERE POD.po_distribution_id = DIST_IDS.num1
AND DIST_IDS.key = p_dist_id_key
FOR UPDATE OF POD.po_distribution_id
NOWAIT
;

Line: 323

SELECT PO_SESSION_GT_S.nextval
INTO l_dist_id_key
FROM DUAL
;

Line: 331

INSERT INTO PO_SESSION_GT ( key, num1 )
VALUES ( l_dist_id_key, l_dist_id_tbl(i) )
;