APPS.PA_RBS_MAPPING dependencies on DBMS_LOCK

Line 35: dbms_lock.allocate_unique(p_lock_name,lockhndl,864000);

31: IS
32: PRAGMA autonomous_transaction;
33: lockhndl varchar2(128);
34: BEGIN
35: dbms_lock.allocate_unique(p_lock_name,lockhndl,864000);
36: commit;
37: RETURN lockhndl;
38: END;
39:

Line 1687: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;

1683:
1684:
1685: /* added for bug#4101364 */
1686: lockhndl := auto_allocate_unique('RBS_VERSION_'||p_rbs_struct_version_id);
1687: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
1688: IF l <>0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
1689: raise can_not_lock_rbs_version;
1690: END IF;
1691:

Line 2329: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;

2325:
2326:
2327: /* added for bug#4102476, 4101364 */
2328: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2329: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2330: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2331: raise can_not_lock_header;
2332: END IF;
2333:

Line 2449: l_release := dbms_lock.release(lockhndl) ;

2445: tab1.expenditure_category_id = ec.expenditure_category_id (+);
2446:
2447: /*bug#4770784, to remove the locking issue changes start*/
2448: IF SQL%ROWCOUNT = 0 THEN
2449: l_release := dbms_lock.release(lockhndl) ;
2450: IF l_release <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2451: raise can_not_release_lock;
2452: END IF;
2453: END IF;