APPS.PO_DOCUMENT_LOCK_GRP dependencies on PO_SESSION_GT

Line 283: -- documents to be locked are available in po_session_gt with key=po_sesiongt_key

279: -- The operating unit context must be set before calling this API - i.e.:
280: --Function:
281: -- Locks the document, including the header and all the lines, shipments,
282: -- and distributions, as appropriate.
283: -- documents to be locked are available in po_session_gt with key=po_sesiongt_key
284: --Modifies:
285: -- Acquires database locks on the document.
286: --Parameters:
287: --IN:

Line 293: -- Docuements to be locked are manitined in po_session_gt

289: -- API version number expected by the caller
290: -- p_init_msg_list:
291: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
292: -- po_sesiongt_key:
293: -- Docuements to be locked are manitined in po_session_gt
294: -- po_sesiongt_key is the key in po_session_gt to identify
295: -- the intended records in the table
296: -- p_online_report_id:
297: -- If the locking of any of teh document contained in po_session_gt fails

Line 294: -- po_sesiongt_key is the key in po_session_gt to identify

290: -- p_init_msg_list:
291: -- If FND_API.G_TRUE, the API will initialize the standard API message list.
292: -- po_sesiongt_key:
293: -- Docuements to be locked are manitined in po_session_gt
294: -- po_sesiongt_key is the key in po_session_gt to identify
295: -- the intended records in the table
296: -- p_online_report_id:
297: -- If the locking of any of teh document contained in po_session_gt fails
298: -- Then an appropriate error message will be inserted in po_online_report_text

Line 297: -- If the locking of any of teh document contained in po_session_gt fails

293: -- Docuements to be locked are manitined in po_session_gt
294: -- po_sesiongt_key is the key in po_session_gt to identify
295: -- the intended records in the table
296: -- p_online_report_id:
297: -- If the locking of any of teh document contained in po_session_gt fails
298: -- Then an appropriate error message will be inserted in po_online_report_text
299: -- table with online_report_id=p_online_report_id
300: -- p_user_id
301: -- Current User Id

Line 323: po_sesiongt_key IN po_session_gt.key%TYPE)

319: p_init_msg_list IN VARCHAR2,
320: x_return_status OUT NOCOPY VARCHAR2,
321: p_user_id IN po_lines.last_updated_by%TYPE,
322: p_login_id IN po_lines.last_update_login%TYPE ,
323: po_sesiongt_key IN po_session_gt.key%TYPE)
324:
325: IS
326:
327: d_api_name CONSTANT VARCHAR2(30) := 'LOCK_DOCUMENT.';

Line 352: po_session_gt gt

348: FROM po_headers POH,
349: po_lines POL,
350: po_line_locations PLL,
351: po_distributions POD,
352: po_session_gt gt
353: WHERE gt.KEY=po_sesiongt_key
354: AND POH.po_header_id =gt.char4
355: AND gt.char1 = 'PO'
356: AND POH.po_header_id = POL.po_header_id (+) -- JOIN

Line 370: po_session_gt gt

366: SELECT 1
367: FROM po_headers POH,
368: po_lines POL,
369: po_line_locations PLL,
370: po_session_gt gt
371: WHERE gt.KEY=po_sesiongt_key
372: AND POH.po_header_id =gt.char4
373: AND gt.char1 = 'PA'
374: AND POH.po_header_id = POL.po_header_id (+) -- JOIN

Line 385: po_session_gt gt

381: CURSOR lock_release_csr IS
382: SELECT 1
383: FROM po_releases POR, po_line_locations PLL,
384: po_distributions POD,
385: po_session_gt gt
386: WHERE gt.KEY=po_sesiongt_key
387: AND POR.po_release_id =gt.char4
388: AND gt.char1 = 'RELEASE'
389: AND POR.po_release_id = PLL.po_release_id (+) -- JOIN