DBA Data[Home] [Help]

APPS.EGO_VS_BULKLOAD_PVT dependencies on EGO_OBJECT_LOCK

Line 2180: INSERT INTO EGO_OBJECT_LOCK

2176:
2177:
2178: -- Inserting record in lock table to lock the record.
2179: -- Need to see if I need to insert it.
2180: INSERT INTO EGO_OBJECT_LOCK
2181: ( LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
2182: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2183: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',l_value_set_id,G_Party_id,'L',
2184: G_Party_id,SYSDATE,G_Party_id,SYSDATE,G_Login_Id) ;

Line 2183: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',l_value_set_id,G_Party_id,'L',

2179: -- Need to see if I need to insert it.
2180: INSERT INTO EGO_OBJECT_LOCK
2181: ( LOCK_ID,OBJECT_NAME,PK1_VALUE,LOCKING_PARTY_ID,LOCK_FLAG,
2182: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
2183: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,'EGO_VALUE_SET',l_value_set_id,G_Party_id,'L',
2184: G_Party_id,SYSDATE,G_Party_id,SYSDATE,G_Login_Id) ;
2185:
2186: write_debug(G_PKG_Name,l_api_name,' Draft Version created ');
2187: --Dbms_Output.put_line(G_PKG_Name||'.'||l_api_name||' Draft Version created ');

Line 2392: -- Insert/update a record into ego_object_lock based on status of lock flag.

2388: END IF;
2389:
2390:
2391: -- Bug 9804411
2392: -- Insert/update a record into ego_object_lock based on status of lock flag.
2393: ego_metadata_bulkload_pvt.Lock_Unlock_Object ( p_object_name => G_OBJECT_VALUE_SET,
2394: p_pk1_value => l_value_set_id,
2395: p_party_id => G_PARTY_ID,
2396: p_lock_flag => l_UnLock,