126: -- that value so that the same number will not be used again the next time
127: -- Generate_LPN is called for that org
128:
129: SELECT lpn_starting_number INTO l_lpn_start_num
130: FROM mtl_parameters
131: WHERE organization_id=p_org_id
132: FOR UPDATE;
133:
134: UPDATE MTL_PARAMETERS
130: FROM mtl_parameters
131: WHERE organization_id=p_org_id
132: FOR UPDATE;
133:
134: UPDATE MTL_PARAMETERS
135: SET lpn_starting_number = l_lpn_start_num+p_qty,
136: last_update_date = SYSDATE,
137: last_updated_by = FND_GLOBAL.USER_ID
138: WHERE organization_id = p_org_id;