APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on DBMS_LOCK

Line 32: DBMS_LOCK.allocate_unique(lock_name_prefix ||

28: IS
29: lock_handle VARCHAR2(128);
30: lock_result INTEGER;
31: BEGIN
32: DBMS_LOCK.allocate_unique(lock_name_prefix ||
33: to_char(X_Chart_Of_Accounts_Id),
34: lock_handle);
35:
36: FOR i IN 1..X_Try_Times LOOP

Line 37: lock_result := DBMS_LOCK.request(lock_handle, X_Lock_Mode,

33: to_char(X_Chart_Of_Accounts_Id),
34: lock_handle);
35:
36: FOR i IN 1..X_Try_Times LOOP
37: lock_result := DBMS_LOCK.request(lock_handle, X_Lock_Mode,
38: X_Timeout_Secs);
39:
40: IF (lock_result IN (0, 4)) THEN
41: -- succeeded

Line 45: DBMS_LOCK.sleep(X_Wait_Secs);

41: -- succeeded
42: RETURN TRUE;
43: ELSIF (lock_result = 1) THEN
44: IF (X_Keep_Trying AND i < X_Try_Times) THEN
45: DBMS_LOCK.sleep(X_Wait_Secs);
46: ELSE
47: RETURN FALSE;
48: END IF;
49: ELSE

Line 64: DBMS_LOCK.allocate_unique(lock_name_prefix ||

60: IS
61: lock_handle VARCHAR2(128);
62: lock_result INTEGER;
63: BEGIN
64: DBMS_LOCK.allocate_unique(lock_name_prefix ||
65: to_char(X_Chart_Of_Accounts_Id),
66: lock_handle);
67: lock_result := DBMS_LOCK.release(lock_handle);
68:

Line 67: lock_result := DBMS_LOCK.release(lock_handle);

63: BEGIN
64: DBMS_LOCK.allocate_unique(lock_name_prefix ||
65: to_char(X_Chart_Of_Accounts_Id),
66: lock_handle);
67: lock_result := DBMS_LOCK.release(lock_handle);
68:
69: IF (lock_result IN (0, 4)) THEN
70: RETURN TRUE;
71: ELSE

Line 130: lock_op_succeeded := request_lock(X_Chart_Of_Accounts_Id, DBMS_LOCK.x_mode,

126:
127: -- Acquire user name lock GL_MGT_SEG_ in exclusive mode
128: lock_name := lock_name_prefix || to_char(X_Chart_Of_Accounts_Id);
129:
130: lock_op_succeeded := request_lock(X_Chart_Of_Accounts_Id, DBMS_LOCK.x_mode,
131: 60, TRUE, 10, 120);
132: IF (NOT lock_op_succeeded) THEN
133: RAISE user_lock_error;
134: END IF;

Line 562: lock_op_succeeded := request_lock(X_Chart_Of_Accounts_Id, DBMS_LOCK.x_mode,

558:
559: -- Acquire user name lock GL_MGT_SEG_ in exclusive mode
560: lock_name := lock_name_prefix || to_char(X_Chart_Of_Accounts_Id);
561:
562: lock_op_succeeded := request_lock(X_Chart_Of_Accounts_Id, DBMS_LOCK.x_mode,
563: 60, TRUE, 10, 120);
564: IF (NOT lock_op_succeeded) THEN
565: RAISE user_lock_error;
566: END IF;