eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_METADATA_BULKLOAD_PVT dependencies on EGO_OBJECT_LOCK

Line 310: FROM EGO_OBJECT_LOCK a

306:
307: CURSOR cur_get_lock_info
308: IS
309: SELECT a.*
310: FROM EGO_OBJECT_LOCK a
311: WHERE a.object_name = p_object_name
312: AND NVL(a.pk1_value, chr(0)) = NVL(p_pk1_value, chr(0))
313: AND NVL(a.pk2_value, chr(0)) = NVL(p_pk2_value, chr(0))
314: AND NVL(a.pk3_value, chr(0)) = NVL(p_pk3_value, chr(0))

Line 319: FROM EGO_OBJECT_LOCK a

315: AND NVL(a.pk4_value, chr(0)) = NVL(p_pk4_value, chr(0))
316: AND NVL(a.pk5_value, chr(0)) = NVL(p_pk5_value, chr(0))
317: AND a.lock_id = (
318: SELECT max(a.lock_id)
319: FROM EGO_OBJECT_LOCK a
320: WHERE a.object_name = p_object_name
321: AND NVL(a.pk1_value, chr(0)) = NVL(p_pk1_value, chr(0))
322: AND NVL(a.pk2_value, chr(0)) = NVL(p_pk2_value, chr(0))
323: AND NVL(a.pk3_value, chr(0)) = NVL(p_pk3_value, chr(0))

Line 474: INSERT INTO EGO_OBJECT_LOCK

470: IF p_lock_flag THEN
471: ---
472: --- Lock the object
473: ---
474: INSERT INTO EGO_OBJECT_LOCK
475: ( lock_id,
476: object_name,
477: pk1_value,
478: pk2_value,

Line 489: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,

485: creation_date,
486: last_updated_by,
487: last_update_date,
488: last_update_login)
489: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,
490: p_object_name,
491: p_pk1_value,
492: p_pk2_value,
493: p_pk3_value,

Line 507: UPDATE EGO_OBJECT_LOCK l

503: ELSE
504: ---
505: --- Unlock the object
506: ---
507: UPDATE EGO_OBJECT_LOCK l
508: SET l.lock_flag = 'U'
509: , l.last_updated_by = g_user_id
510: , l.last_update_date = l_sysdate
511: , l.last_update_login = g_login_id

Line 519: FROM EGO_OBJECT_LOCK a

515: AND NVL(l.pk3_value, chr(0)) = NVL(p_pk3_value, chr(0))
516: AND NVL(l.pk4_value, chr(0)) = NVL(p_pk4_value, chr(0))
517: AND NVL(l.pk5_value, chr(0)) = NVL(p_pk5_value, chr(0))
518: AND l.lock_id = ( SELECT max(a.lock_id)
519: FROM EGO_OBJECT_LOCK a
520: WHERE a.object_name = p_object_name
521: AND NVL(a.pk1_value, chr(0)) = NVL(p_pk1_value, chr(0))
522: AND NVL(a.pk2_value, chr(0)) = NVL(p_pk2_value, chr(0))
523: AND NVL(a.pk3_value, chr(0)) = NVL(p_pk3_value, chr(0))