APPS.MRP_REL_PLAN_PUB dependencies on DBMS_LOCK

Line 124: dbms_lock.allocate_unique(arg_compile_desig||to_char(arg_org_id),

120: -- where we need to do batch processing
121: -- If mode is WF, then we need to do this work only for the
122: -- transaction_id that is passed in
123:
124: dbms_lock.allocate_unique(arg_compile_desig||to_char(arg_org_id),
125: var_handle);
126:
127: var_output := dbms_lock.request(var_handle, 6, 32767, TRUE);
128: var_upd_req_date_rel := NVL(FND_PROFILE.VALUE('MRP_UPD_REQ_DATE_REL'),'N');

Line 127: var_output := dbms_lock.request(var_handle, 6, 32767, TRUE);

123:
124: dbms_lock.allocate_unique(arg_compile_desig||to_char(arg_org_id),
125: var_handle);
126:
127: var_output := dbms_lock.request(var_handle, 6, 32767, TRUE);
128: var_upd_req_date_rel := NVL(FND_PROFILE.VALUE('MRP_UPD_REQ_DATE_REL'),'N');
129: if(var_output <> 0) then
130: FND_MESSAGE.SET_NAME('MRP', 'GEN-LOCK-WARNING');
131: FND_MESSAGE.SET_TOKEN('EVENT', 'RELEASE PLANNED ORDERS');