APPS.PO_DOCUMENT_LOCK_GRP dependencies on PO_ONLINE_REPORT_TEXT

Line 298: -- Then an appropriate error message will be inserted in po_online_report_text

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
302: -- p_login_id

Line 332: l_sequence po_online_report_text.sequence%TYPE;

328: d_module CONSTANT VARCHAR2(100) := g_module_prefix || d_api_name;
329:
330: l_progress VARCHAR2(3);
331: l_api_version CONSTANT NUMBER := 1.0;
332: l_sequence po_online_report_text.sequence%TYPE;
333:
334:
335: -- ORA-00054 is the resource busy exception, which is raised when we try
336: -- to lock a row that is already locked by another session.

Line 433: FROM PO_ONLINE_REPORT_TEXT

429: l_progress :='001';
430:
431: SELECT Nvl(Max(sequence) ,0)
432: INTO l_sequence
433: FROM PO_ONLINE_REPORT_TEXT
434: WHERE online_report_id=p_online_report_id;
435:
436: IF (g_fnd_debug = 'Y') THEN
437: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 477: INSERT INTO PO_ONLINE_REPORT_TEXT

473: END IF;
474:
475: EXCEPTION
476: WHEN resource_busy_exc THEN -- Cannot acquire the lock
477: INSERT INTO PO_ONLINE_REPORT_TEXT
478: (ONLINE_REPORT_ID,
479: LAST_UPDATE_LOGIN,
480: LAST_UPDATED_BY,
481: LAST_UPDATE_DATE,