APPS.PO_LOCKS dependencies on PO_SESSION_GT

Line 86: -- PO_SESSION_GT column mapping

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

Line 95: , PO_SESSION_GT IDS

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

Line 106: , PO_SESSION_GT IDS

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

Line 117: , PO_SESSION_GT IDS

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

Line 131: , PO_SESSION_GT IDS

127: CURSOR l_rcv_lock_req_csr(p_doc_id_key NUMBER) IS
128: SELECT NULL
129: FROM
130: PO_REQUISITION_HEADERS_ALL PRH
131: , PO_SESSION_GT IDS
132: WHERE PRH.requisition_header_id = IDS.num1
133: AND IDS.key = p_doc_id_key
134: FOR UPDATE
135: ;

Line 141: , PO_SESSION_GT IDS

137: CURSOR l_rcv_lock_release_csr(p_doc_id_key NUMBER) IS
138: SELECT NULL
139: FROM
140: PO_RELEASES_ALL POR
141: , PO_SESSION_GT IDS
142: WHERE POR.po_release_id = IDS.num1
143: AND IDS.key = p_doc_id_key
144: FOR UPDATE
145: ;

Line 151: , PO_SESSION_GT IDS

147: CURSOR l_rcv_lock_po_csr(p_doc_id_key NUMBER) IS
148: SELECT NULL
149: FROM
150: PO_HEADERS_ALL POH
151: , PO_SESSION_GT IDS
152: WHERE POH.po_header_id = IDS.num1
153: AND IDS.key = p_doc_id_key
154: FOR UPDATE
155: ;

Line 183: SELECT PO_SESSION_GT_S.nextval

179: l_progress := '020';
180:
181: -- Put the header ids into the scratchpad so that the cursors work.
182:
183: SELECT PO_SESSION_GT_S.nextval
184: INTO l_doc_id_key
185: FROM DUAL
186: ;
187:

Line 191: INSERT INTO PO_SESSION_GT ( key, num1 )

187:
188: l_progress := '030';
189:
190: FORALL i IN 1 .. l_doc_id_tbl.COUNT
191: INSERT INTO PO_SESSION_GT ( key, num1 )
192: VALUES ( l_doc_id_key, l_doc_id_tbl(i) )
193: ;
194:
195: l_progress := '040';

Line 359: -- PO_SESSION_GT column mapping

355: l_dist_id_tbl po_tbl_number;
356: l_dist_id_key NUMBER;
357:
358: ----------------------------------------------------------------
359: -- PO_SESSION_GT column mapping
360: --
361: -- num1 distribution id
362: ----------------------------------------------------------------
363:

Line 368: , PO_SESSION_GT DIST_IDS

364: CURSOR l_lock_req_csr(p_dist_id_key NUMBER) IS
365: SELECT NULL
366: FROM
367: PO_REQ_DISTRIBUTIONS_ALL PRD
368: , PO_SESSION_GT DIST_IDS
369: WHERE PRD.distribution_id = DIST_IDS.num1
370: AND DIST_IDS.key = p_dist_id_key
371: FOR UPDATE OF PRD.distribution_id
372: NOWAIT

Line 379: , PO_SESSION_GT DIST_IDS

375: CURSOR l_lock_nonreq_csr(p_dist_id_key NUMBER) IS
376: SELECT NULL
377: FROM
378: PO_DISTRIBUTIONS_ALL POD
379: , PO_SESSION_GT DIST_IDS
380: WHERE POD.po_distribution_id = DIST_IDS.num1
381: AND DIST_IDS.key = p_dist_id_key
382: FOR UPDATE OF POD.po_distribution_id
383: NOWAIT

Line 411: SELECT PO_SESSION_GT_S.nextval

407:
408: -- Put the distribution ids in the scratchpad, so that the
409: -- cursors will work (PL/SQL locking limitations).
410:
411: SELECT PO_SESSION_GT_S.nextval
412: INTO l_dist_id_key
413: FROM DUAL
414: ;
415:

Line 419: INSERT INTO PO_SESSION_GT ( key, num1 )

415:
416: l_progress := '020';
417:
418: FORALL i IN 1 .. l_dist_id_tbl.COUNT
419: INSERT INTO PO_SESSION_GT ( key, num1 )
420: VALUES ( l_dist_id_key, l_dist_id_tbl(i) )
421: ;
422:
423: l_progress := '030';