APPS.HR_KI_TIS_LOAD_API dependencies on DBMS_LOCK

Line 51: DBMS_LOCK.ALLOCATE_UNIQUE

47: WHERE topic_integrations_id = x_topic_integrations_id;
48: --
49: begin
50: --
51: DBMS_LOCK.ALLOCATE_UNIQUE
52: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
53: ,LOCKHANDLE => L_LOCK_HANDLE
54: );
55: L_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 55: L_RETURN_VALUE := DBMS_LOCK.REQUEST

51: DBMS_LOCK.ALLOCATE_UNIQUE
52: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
53: ,LOCKHANDLE => L_LOCK_HANDLE
54: );
55: L_RETURN_VALUE := DBMS_LOCK.REQUEST
56: (LOCKHANDLE => L_LOCK_HANDLE
57: ,TIMEOUT => 0
58: ,RELEASE_ON_COMMIT => true);
59:

Line 178: DBMS_LOCK.ALLOCATE_UNIQUE

174: L_LOCK_HANDLE varchar2(500);
175: L_RETURN_VALUE number;
176: --
177: begin
178: DBMS_LOCK.ALLOCATE_UNIQUE
179: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
180: ,LOCKHANDLE => L_LOCK_HANDLE
181: );
182: L_RETURN_VALUE := DBMS_LOCK.REQUEST

Line 182: L_RETURN_VALUE := DBMS_LOCK.REQUEST

178: DBMS_LOCK.ALLOCATE_UNIQUE
179: (LOCKNAME =>'HR_KI_TOPIC_INTEGRATIONS.'||X_TOPIC_INTEGRATIONS_ID
180: ,LOCKHANDLE => L_LOCK_HANDLE
181: );
182: L_RETURN_VALUE := DBMS_LOCK.REQUEST
183: (LOCKHANDLE => L_LOCK_HANDLE
184: ,TIMEOUT => 0
185: ,RELEASE_ON_COMMIT => true);
186: --