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 1690: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;

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

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

2660:
2661:
2662: /* added for bug#4102476, 4101364 */
2663: lockhndl := auto_allocate_unique('LOCK_PJI_FP_TXN_ACCUM_HEADER');
2664: l := dbms_lock.request(lockhndl, 6, 864000, TRUE) ;
2665: IF l <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2666: raise can_not_lock_header;
2667: END IF;
2668:

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

2780: tab1.expenditure_category_id = ec.expenditure_category_id (+);
2781:
2782: /*bug#4770784, to remove the locking issue changes start*/
2783: IF SQL%ROWCOUNT = 0 THEN
2784: l_release := dbms_lock.release(lockhndl) ;
2785: IF l_release <> 0 AND l <> 4 THEN -- 4 has been added to make it compatible within same session
2786: raise can_not_release_lock;
2787: END IF;
2788: END IF;