APPS.PO_LOCKS dependencies on PO_SESSION_GT

Line 85: -- PO_SESSION_GT column mapping

81: l_doc_id_tbl po_tbl_number;
82: l_doc_id_key NUMBER;
83:
84: ----------------------------------------------------------------
85: -- PO_SESSION_GT column mapping
86: --
87: -- num1 doc id
88: ----------------------------------------------------------------
89:

Line 94: , PO_SESSION_GT IDS

90: CURSOR l_lock_req_csr(p_doc_id_key NUMBER) IS
91: SELECT NULL
92: FROM
93: PO_REQUISITION_HEADERS_ALL PRH
94: , PO_SESSION_GT IDS
95: WHERE PRH.requisition_header_id = IDS.num1
96: AND IDS.key = p_doc_id_key
97: FOR UPDATE OF PRH.requisition_header_id
98: NOWAIT

Line 105: , PO_SESSION_GT IDS

101: CURSOR l_lock_release_csr(p_doc_id_key NUMBER) IS
102: SELECT NULL
103: FROM
104: PO_RELEASES_ALL POR
105: , PO_SESSION_GT IDS
106: WHERE POR.po_release_id = IDS.num1
107: AND IDS.key = p_doc_id_key
108: FOR UPDATE OF POR.po_release_id
109: NOWAIT

Line 116: , PO_SESSION_GT IDS

112: CURSOR l_lock_po_csr(p_doc_id_key NUMBER) IS
113: SELECT NULL
114: FROM
115: PO_HEADERS_ALL POH
116: , PO_SESSION_GT IDS
117: WHERE POH.po_header_id = IDS.num1
118: AND IDS.key = p_doc_id_key
119: FOR UPDATE OF POH.po_header_id
120: NOWAIT

Line 147: SELECT PO_SESSION_GT_S.nextval

143: l_progress := '020';
144:
145: -- Put the header ids into the scratchpad so that the cursors work.
146:
147: SELECT PO_SESSION_GT_S.nextval
148: INTO l_doc_id_key
149: FROM DUAL
150: ;
151:

Line 155: INSERT INTO PO_SESSION_GT ( key, num1 )

151:
152: l_progress := '030';
153:
154: FORALL i IN 1 .. l_doc_id_tbl.COUNT
155: INSERT INTO PO_SESSION_GT ( key, num1 )
156: VALUES ( l_doc_id_key, l_doc_id_tbl(i) )
157: ;
158:
159: l_progress := '040';

Line 271: -- PO_SESSION_GT column mapping

267: l_dist_id_tbl po_tbl_number;
268: l_dist_id_key NUMBER;
269:
270: ----------------------------------------------------------------
271: -- PO_SESSION_GT column mapping
272: --
273: -- num1 distribution id
274: ----------------------------------------------------------------
275:

Line 280: , PO_SESSION_GT DIST_IDS

276: CURSOR l_lock_req_csr(p_dist_id_key NUMBER) IS
277: SELECT NULL
278: FROM
279: PO_REQ_DISTRIBUTIONS_ALL PRD
280: , PO_SESSION_GT DIST_IDS
281: WHERE PRD.distribution_id = DIST_IDS.num1
282: AND DIST_IDS.key = p_dist_id_key
283: FOR UPDATE OF PRD.distribution_id
284: NOWAIT

Line 291: , PO_SESSION_GT DIST_IDS

287: CURSOR l_lock_nonreq_csr(p_dist_id_key NUMBER) IS
288: SELECT NULL
289: FROM
290: PO_DISTRIBUTIONS_ALL POD
291: , PO_SESSION_GT DIST_IDS
292: WHERE POD.po_distribution_id = DIST_IDS.num1
293: AND DIST_IDS.key = p_dist_id_key
294: FOR UPDATE OF POD.po_distribution_id
295: NOWAIT

Line 323: SELECT PO_SESSION_GT_S.nextval

319:
320: -- Put the distribution ids in the scratchpad, so that the
321: -- cursors will work (PL/SQL locking limitations).
322:
323: SELECT PO_SESSION_GT_S.nextval
324: INTO l_dist_id_key
325: FROM DUAL
326: ;
327:

Line 331: INSERT INTO PO_SESSION_GT ( key, num1 )

327:
328: l_progress := '020';
329:
330: FORALL i IN 1 .. l_dist_id_tbl.COUNT
331: INSERT INTO PO_SESSION_GT ( key, num1 )
332: VALUES ( l_dist_id_key, l_dist_id_tbl(i) )
333: ;
334:
335: l_progress := '030';